[3.3.5] DB/Quest: It Rolls Downhill

[SnapperRy]

Description: the quest currently doesn't work very well. This aims to fix that.

Current issues:

• The charmed geists do not follow the player on charm.
• The sequence of events is wrong.
• The dummy NPCs (Geist WP Bunny) are not sniffed.
• The charmed geist attacks the player when the debuff ends.

Branch(es): 3.3.5

TC hash/commit: 025002b

TDB version: 335.61

Suggested fix (WIP):

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=52245;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(17, 0, 52245, 0, 0, 29, 0, 28751, 10, 0, 0, 0, 0, "", "Spell 'Harvest Blight Crystal' requires NPC 'Geist WP Bunny' within 10 yards");

SET @GUID := xxx; -- Need 20
DELETE FROM `creature` WHERE `id`=28751;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@GUID   , 28751, 571, 0, 0, 1, 1, 0, 0, 6205.66,-2031.33, 231.957, 1.4648, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+1 , 28751, 571, 0, 0, 1, 1, 0, 0, 6203.13,-2045.03, 231.718, 1.93604, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+2 , 28751, 571, 0, 0, 1, 1, 0, 0, 6194.06,-2058.3, 231.691, 1.42475, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+3 , 28751, 571, 0, 0, 1, 1, 0, 0, 6190.1,-2074.08, 234.049, 5.82455, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+4 , 28751, 571, 0, 0, 1, 1, 0, 0, 6162.49,-2052.57, 232.259, 3.80608, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+5 , 28751, 571, 0, 0, 1, 1, 0, 0, 6150.48,-2031.49, 232.446, 4.15951, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+6 , 28751, 571, 0, 0, 1, 1, 0, 0, 6146.68,-2042.82, 231.738, 4.35664, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+7 , 28751, 571, 0, 0, 1, 1, 0, 0, 6149.27,-2074.68, 235.134, 5.59683, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+8 , 28751, 571, 0, 0, 1, 1, 0, 0, 6135.15,-2046.03, 232.054, 5.90392, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+9 , 28751, 571, 0, 0, 1, 1, 0, 0, 6110.64,-2032.95, 234.108, 5.03213, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+10, 28751, 571, 0, 0, 1, 1, 0, 0, 6134.49,-1969.1, 234.555, 1.83321, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+11, 28751, 571, 0, 0, 1, 1, 0, 0, 6128.76,-1992.91, 232.073, 2.89978, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+12, 28751, 571, 0, 0, 1, 1, 0, 0, 6143.92,-1996.31, 231.799, 2.41833, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+13, 28751, 571, 0, 0, 1, 1, 0, 0, 6163.55,-1977.1, 231.973, 1.92746, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+14, 28751, 571, 0, 0, 1, 1, 0, 0, 6164.93,-1952.22, 234.573, 4.26402, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+15, 28751, 571, 0, 0, 1, 1, 0, 0, 6193.32,-1975.39, 231.736, 1.59994, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+16, 28751, 571, 0, 0, 1, 1, 0, 0, 6199.8,-1963.58, 233.579, 1.92985, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+17, 28751, 571, 0, 0, 1, 1, 0, 0, 6241.15,-2024.02, 233.86, 0.479129, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+18, 28751, 571, 0, 0, 1, 1, 0, 0, 6215.06,-2061.93, 233.168, 6.03346, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0),
(@GUID+19, 28751, 571, 0, 0, 1, 1, 0, 0, 6200.76,-1994.65, 231.809, 1.2716, 300, 0, 0, 4979, 0, 0, 0, 0, 0, 0);

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28750, 2875000, 2875001);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(28750, 0, 0, 0, 8, 0, 100, 512, 52245, 0, 0, 0, 69, 1, 0, 1, 0, 0, 0, 11, 28751, 10, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Harvest Blight Crystal' - Move To Closest Gameobject 'Crystallized Blight'"),
(28750, 0, 1, 2, 8, 0, 100, 512, 52244, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Geist' - Say Line 0"),
(28750, 0, 2, 0, 61, 0, 100, 512, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Geist' - Follow Invoker"),
(28750, 0, 3, 0, 8, 0, 100, 512, 52252, 0, 0, 0, 11, 52243, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Channel' - Cast 'Orange Radiation, Small'"),
(28750, 0, 4, 0, 34, 0, 100, 512, 0, 1, 0, 0, 80, 2875000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On MovePoint 1 Reached - Run Script"),
(28750, 0, 5, 0, 34, 0, 100, 512, 0, 2, 0, 0, 80, 2875001, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On MovePoint 2 Reached - Run Script"),

(2875000, 9, 0, 0, 0, 0, 100, 512, 4000, 4000, 4000, 4000, 11, 52247, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Target Crystal'"),
(2875000, 9, 1, 0, 0, 0, 100, 512, 1000, 1000, 1000, 1000, 69, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 6174.28, -2017.25, 245.116, 0, "Blight Geist - On Script - Move to Target Position"),

(2875001, 9, 0, 0, 0, 0, 100, 512, 4000, 4000, 4000, 4000, 11, 61456, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Evil Teleport Visual Only'"),
(2875001, 9, 1, 0, 0, 0, 100, 513, 2000, 2000, 2000, 2000, 11, 52248, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Kill Credit - Blighted Geist'"),
(2875001, 9, 2, 0, 0, 0, 100, 512, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Despawn in 5 seconds");

[dr-j]

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@CGUID+300, 28751, 571, 1, 1, '', 6129.368, -2015.601, 231.8592, 5.532694, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+301, 28751, 571, 1, 1, '', 6124.152, -2007.818, 232.2949, 4.729842, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+306, 28751, 571, 1, 1, '', 6123.972, -2021.866, 231.8847, 5.235988, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+307, 28751, 571, 1, 1, '', 6145.535, -2016.273, 241.1688, 4.991642, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+309, 28751, 571, 1, 1, '', 6174.213, -2046.936, 241.1631, 3.944444, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+310, 28751, 571, 1, 1, '', 6176.545, -1970.191, 232.2983, 2.80998, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+312, 28751, 571, 1, 1, '', 6161.737, -2067.135, 233.2621, 1.850049, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+313, 28751, 571, 1, 1, '', 6176.255, -1987.595, 241.1641, 4.433136, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+317, 28751, 571, 1, 1, '', 6175.281, -2017.28, 245.1609, 1.989675, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+320, 28751, 571, 1, 1, '', 6171.421, -2062.37, 231.7733, 1.605703, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+321, 28751, 571, 1, 1, '', 6166.295, -1965.434, 233.2561, 0.6283185, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+329, 28751, 571, 1, 1, '', 6189.294, -1966.913, 232.8602, 3.054326, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+330, 28751, 571, 1, 1, '', 6180.967, -2067.945, 232.525, 0.2094395, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+336, 28751, 571, 1, 1, '', 6223.343, -2029.306, 232.0312, 1.53589, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+337, 28751, 571, 1, 1, '', 6223.972, -2008.706, 232.3687, 4.572762, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+340, 28751, 571, 1, 1, '', 6219.575, -2018.262, 231.7784, 6.021386, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+342, 28751, 571, 1, 1, '', 6204.822, -2018.329, 241.1961, 5.078908, 120, 0, 0), -- 28751 (Area: 66)

[dr-j]

Ok have done a little work on this but still not working as intended,

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=52245;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(17, 0, 52245, 0, 0, 29, 0, 28751, 40, 0, 0, 0, 0, "", "Spell 'Harvest Blight Crystal' requires NPC 'Geist WP Bunny' within 10 yards");

SET @GUID := XXX; -- Need 17
DELETE FROM `creature` WHERE `id`=28751;


INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@CGUID+0, 28751, 571, 1, 1, 6129.368, -2015.601, 231.8592, 5.532694, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+1, 28751, 571, 1, 1, 6124.152, -2007.818, 232.2949, 4.729842, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+2, 28751, 571, 1, 1, 6123.972, -2021.866, 231.8847, 5.235988, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+3, 28751, 571, 1, 1, 6145.535, -2016.273, 241.1688, 4.991642, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+4, 28751, 571, 1, 1, 6174.213, -2046.936, 241.1631, 3.944444, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+5, 28751, 571, 1, 1, 6176.545, -1970.191, 232.2983, 2.80998, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+6, 28751, 571, 1, 1, 6161.737, -2067.135, 233.2621, 1.850049, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+7, 28751, 571, 1, 1, 6176.255, -1987.595, 241.1641, 4.433136, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+8, 28751, 571, 1, 1, 6175.281, -2017.28, 245.1609, 1.989675, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+9, 28751, 571, 1, 1, 6171.421, -2062.37, 231.7733, 1.605703, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+10, 28751, 571, 1, 1, 6166.295, -1965.434, 233.2561, 0.6283185, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+11, 28751, 571, 1, 1, 6189.294, -1966.913, 232.8602, 3.054326, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+12, 28751, 571, 1, 1, 6180.967, -2067.945, 232.525, 0.2094395, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+13, 28751, 571, 1, 1, 6223.343, -2029.306, 232.0312, 1.53589, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+14, 28751, 571, 1, 1, 6223.972, -2008.706, 232.3687, 4.572762, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+15, 28751, 571, 1, 1, 6219.575, -2018.262, 231.7784, 6.021386, 120, 0, 0), -- 28751 (Area: 66)
(@CGUID+16, 28751, 571, 1, 1, 6204.822, -2018.329, 241.1961, 5.078908, 120, 0, 0); -- 28751 (Area: 66)


DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28750, 2875000, 2875001);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(28750, 0, 0, 0, 8, 0, 100, 512, 52245, 0, 0, 0, 69, 1, 0, 1, 0, 0, 0, 11, 28751, 10, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Harvest Blight Crystal' - Move To Closest Gameobject 'Crystallized Blight'"),
(28750, 0, 1, 2, 8, 0, 100, 512, 52244, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Geist' - Say Line 0"),
(28750, 0, 2, 0, 61, 0, 100, 512, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Geist' - Follow Invoker"),
(28750, 0, 3, 0, 8, 0, 100, 512, 52252, 0, 0, 0, 11, 52243, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Channel' - Cast 'Orange Radiation, Small'"),
(28750, 0, 4, 0, 34, 0, 100, 512, 0, 1, 0, 0, 80, 2875000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On MovePoint 1 Reached - Run Script"),
(28750, 0, 5, 0, 34, 0, 100, 512, 0, 2, 0, 0, 80, 2875001, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On MovePoint 2 Reached - Run Script"),

(28750, 0, 6, 7, 29, 0, 100, 512, 1, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Charm Removed - Stop Follow"),
(28750, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Charm Removed - Evade"),

(2875000, 9, 0, 0, 0, 0, 100, 512, 4000, 4000, 4000, 4000, 11, 52247, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Target Crystal'"),
(2875000, 9, 1, 0, 0, 0, 100, 512, 1000, 1000, 1000, 1000, 69, 2, 0, 0, 0, 0, 0, 8, 0, 0, 0, 6174.28, -2017.25, 245.116, 0, "Blight Geist - On Script - Move to Target Position"),

(2875001, 9, 0, 0, 0, 0, 100, 512, 4000, 4000, 4000, 4000, 11, 61456, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Evil Teleport Visual Only'"),
(2875001, 9, 1, 0, 0, 0, 100, 513, 2000, 2000, 2000, 2000, 11, 52248, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Kill Credit - Blighted Geist'"),
(2875001, 9, 2, 0, 0, 0, 100, 512, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Evade"),
(2875001, 9, 3, 0, 0, 0, 100, 512, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Despawn in 5 seconds");

Geists still attack after 60 seconds of being charmed, tried a few things to prevent this but still now working
The sniffed positions of the GEIST WP BUNNYS do not line up with crystalized blight
The WP Bunnys are at the bottom of each path leading to teleporter and at top by each teleportet think these mark the path taken after the geist harvests the blight not when harvesting.

[SnapperRy]

That's strange. If there are no bunnies for the crystalized blight harvest positions, then it is probably calculated based on the geist's orientation. That would require a c++ script for the targeting spells, as I guess that is the one used.

[dr-j]

http://www.wowhead.com/spell=52247/target-crystal

ID - 52247 Target Crystal
=================================================
Category = 0, SpellIconID = 1, activeIconID = 0, SpellVisual = (0,0)
Family SPELLFAMILY_GENERIC, flag 0x00000000 00000000 00000000

SpellSchoolMask = 1 (SPELL_SCHOOL_MASK_NORMAL)
DamageClass = 0 (SPELL_DAMAGE_CLASS_NONE)
PreventionType = 0 (SPELL_PREVENTION_TYPE_NONE)
=================================================
Attributes: 0x00000100 (SPELL_ATTR0_HIDE_IN_COMBAT_LOG)
=================================================
Spell Level = 0, base 0, max 0, maxTarget 0

Category = 0
DispelType = 0 (DISPEL_NONE)
Mechanic = 0 (MECHANIC_NONE)
SpellRange: (Id 3) "Twenty yards":
    MinRange = 0, MinRangeFriendly = 0
    MaxRange = 20, MaxRangeFriendly = 20

CastingTime (Id 1) = 0.00

Interrupt Flags: 0x00000000, AuraIF 0x00000000, ChannelIF 0x00000000
Chance = 101, charges - 0
=================================================
Effect 0: Id 3 (SPELL_EFFECT_DUMMY)
BasePoints = 1
Targets (40, 0) (TARGET_GAMEOBJECT_NEARBY_ENTRY, NO_TARGET)

Effect 1:  NO EFFECT

Effect 2:  NO EFFECT

[dewmguy]

Current gameplay of the quest. It seems like every geist, no matter where it happens to be when you use the Scepter of Suggestion, runs straight to south, falls through the ground, collects a Blight Crystal, and then doesn't come back unless you click "follow me" in the pet bar. Also when the control effect wears off, the geist engages in combat immediately before despawning.

[Rushor]

The charmed geist attacks the player when the debuff ends.

That is generic issue i think - has this not been fixed yet?

[Killyana]

It's fixed

[Killyana]

There's 2 Issues to fix:
1- General SAI issue: when you tell a creature to move to a unit and this unit is not present, nothing must happen, in the current revision the npc will move to map coords 0,0,0
2- This Blight Geist must have only one spell in the control bar, no movements or attack action must be displayed, otherwise it will screwed up the script.
From retail:

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28750, 2875000, 2875001, 2875002);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(28750, 0, 0, 0, 8, 0, 100, 512, 52244, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Geist' - Say Line 0"),
(28750, 0, 1, 0, 8, 0, 100, 512, 52245, 0, 0, 0, 80, 2875001, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Harvest Blight Crystal' - On Script"),
(28750, 0, 2, 0, 8, 0, 100, 512, 52244, 0, 0, 0, 28, 52243, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Charm Geist' - Remove aura"),
(2875001, 9, 0, 0, 0, 0, 100, 512, 0, 0, 0, 0, 5, 25, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Play emote"),
(2875001, 9, 1, 0, 0, 0, 100, 512, 2000, 2000, 0, 0, 69, 1, 0, 0, 2, 0, 0, 20, 190716, 10, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Harvest Blight Crystal' - Move To Closest Gameobject 'Crystallized Blight'"),
(2875001, 9, 2, 0, 0, 0, 100, 512, 0, 0, 0, 0, 69, 1, 0, 0, 2, 0, 0, 20, 190939, 10, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Harvest Blight Crystal' - Move To Closest Gameobject 'Crystallized Blight'"),
(2875001, 9, 3, 0, 0, 0, 100, 512, 0, 0, 0, 0, 69, 1, 0, 0, 2, 0, 0, 20, 190940, 10, 0, 0, 0, 0, 0, "Blight Geist - On Spellhit 'Harvest Blight Crystal' - Move To Closest Gameobject 'Crystallized Blight'"),

(28750, 0, 3, 0, 34, 0, 100, 513, 8, 1, 0, 0, 80, 2875000, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On movment informer - Run Script"),
(2875000, 9, 0, 0, 0, 0, 100, 512, 0, 0, 0, 0, 18, 33032, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Set unitflags"),
(2875000, 9, 1, 0, 0, 0, 100, 512, 1000, 1000, 0, 0, 5, 36, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Play emote"),
(2875000, 9, 2, 0, 0, 0, 100, 512, 0, 0, 0, 0, 11, 52243, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Orange Radiation, Small'"),
(2875000, 9, 3, 0, 0, 0, 100, 512, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 190716, 4, 0, 0, 0, 0, 0, "Blight Geist - On Script - Despawn gob"),
(2875000, 9, 4, 0, 0, 0, 100, 512, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 190939, 4, 0, 0, 0, 0, 0, "Blight Geist - On Script - Despawn gob"),
(2875000, 9, 5, 0, 0, 0, 100, 512, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 190940, 4, 0, 0, 0, 0, 0, "Blight Geist - On Script - Despawn gob"),
(2875000, 9, 6, 0, 0, 0, 100, 512, 1000, 1000, 0, 0, 69, 2, 0, 0, 0, 0, 0, 8, 0, 0, 0, 6174.28, -2017.25, 245.116, 0, "Blight Geist - On Script - Move To Self"),

(28750, 0, 4, 0, 34, 0, 100, 513, 8, 2, 0, 0, 80, 2875002, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On movment informer - Run Script"),
(2875002, 9, 0, 0, 0, 0, 100, 512, 1000, 1000, 0, 0, 11, 52248, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Kill Credit - Blighted Geist'"),
(2875002, 9, 1, 0, 0, 0, 100, 512, 1000, 1000, 0, 0, 11, 61456, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Cast 'Evil Teleport Visual Only'"),
(2875002, 9, 2, 0, 0, 0, 100, 512, 1000, 1000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Blight Geist - On Script - Despawn");

DELETE FROM `conditions` WHERE `SourceEntry` IN (28750);