DB/Misc: Various Fixes

1) SIlithid Invader/Hive Drone Pooling
2) Plump Turkey Script (Keep away from fires) just walks into fire rather than jumping though
3) Temporal Parasite only remaining issue now is that when player uses quest item 3 parasites will always respawn rather than 1-3, chance for additional to spawn on death and the Temporal rift will now despawn when item used preventing the quest item been used on same silo until it respawns
4) Screecher spirits - despawn corpse rather than player been able to complete quest while killing only a single mob

1 files changed, 71 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_11_26_06_world335.sql b/sql/updates/world/3.3.5/2016_11_26_06_world335.sql
new file mode 100644
index 00000000000..2fb87354166
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_11_26_06_world335.sql
@@ -0,0 +1,71 @@
+SET @CGUID := 86075;
+SET @POOL := 32492;
+
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6 AND `id`=4131;
+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`, `spawntimevariance`, `VerifiedBuild`) VALUES
+(@CGUID+0, 4131, 1, 0, 0, 1, 1, 11143, 0, -6484.09, -3229.87, -112.36, 3.42467, 300, 3, 0, 1221, 0, 1, 0, 0, 0, 0, 0),
+(@CGUID+1, 4131, 1, 0, 0, 1, 1, 11143, 0, -6472.31, -3243.75, -113.38, 5.96223, 300, 3, 0, 1221, 0, 1, 0, 0, 0, 0, 0),
+(@CGUID+2, 4131, 1, 0, 0, 1, 1, 11143, 0, -6491.48, -3245.93, -112.497, 6.10384, 300, 3, 0, 1221, 0, 1, 0, 0, 0, 0, 0),
+(@CGUID+3, 4131, 1, 0, 0, 1, 1, 11143, 0, -6462.86, -3297.58, -104.92, 1.41244, 300, 3, 0, 1221, 0, 1, 0, 0, 0, 0, 0),
+(@CGUID+4, 4131, 1, 0, 0, 1, 1, 11143, 0, -6485.84, -3254.02, -113.549, 0.814107, 300, 3, 0, 1221, 0, 1, 0, 0, 0, 0, 0),
+(@CGUID+5, 4131, 1, 0, 0, 1, 1, 11143, 0, -6488.36, -3323.74, -94.8076, 3.46016, 300, 5, 0, 1221, 0, 1, 0, 0, 0, 0, 0),
+(@CGUID+6, 4131, 1, 0, 0, 1, 1, 11143, 0, -6496.03, -3325.49, -95.8035, 2.63545, 300, 3, 0, 1221, 0, 1, 0, 0, 0, 0, 0);
+
+DELETE FROM `pool_creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6 AND `pool_entry` BETWEEN @Pool AND @Pool+6;
+DELETE FROM `pool_creature` WHERE `guid` IN(21317,21318,21314,21324,21323,21325,21327) AND `pool_entry` BETWEEN @Pool AND @Pool+6;
+INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
+(@CGUID+0, @Pool, 0, 'Silithid Invader'),
+(21317, @Pool, 0, 'Silithid Hive Drone'),
+(@CGUID+1, @Pool+1, 0, 'Silithid Invader'),
+(21318, @Pool+1, 0, 'Silithid Hive Drone'),
+(@CGUID+2, @Pool+2, 0, 'Silithid Invader'),
+(21314, @Pool+2, 0, 'Silithid Hive Drone'),
+(@CGUID+3, @Pool+3, 0, 'Silithid Invader'),
+(21324, @Pool+3, 0, 'Silithid Hive Drone'),
+(@CGUID+4, @Pool+4, 0, 'Silithid Invader'),
+(21323, @Pool+4, 0, 'Silithid Hive Drone'),
+(@CGUID+5, @Pool+5, 0, 'Silithid Invader'),
+(21325, @Pool+5, 0, 'Silithid Hive Drone'),
+(@CGUID+6, @Pool+6, 0, 'Silithid Invader'),
+(21327, @Pool+6, 0, 'Silithid Hive Drone');
+
+DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOL+0 AND @POOL+6;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(@POOL+0, 1, 'Silithid Invader/drone pool 1'),
+(@POOL+1, 1, 'Silithid Invader/drone pool 2'),
+(@POOL+2, 1, 'Silithid Invader/drone pool 3'),
+(@POOL+3, 1, 'Silithid Invader/drone pool 4'),
+(@POOL+4, 1, 'Silithid Invader/drone pool 5'),
+(@POOL+5, 1, 'Silithid Invader/drone pool 6'),
+(@POOL+6, 1, 'Silithid Invader/drone pool 7');
+
+UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE  `entry`=32818;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=32818 AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=3281800 AND `source_type`=9;
+
+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
+(32818, 0, 0, 0, 76, 0, 100, 513, 0, 31442, 6, 0, 80, 3281800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plump Turkey - On Basic Campfire (Trap) within 10 yrds - run script (no repeat)'),
+(3281800, 9, 0, 0, 0, 0, 100, 513, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plump Turkey - Script - Stop Follow'),
+(3281800, 9, 1, 0, 0, 0, 100, 513, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plump Turkey - Script - Set Run'),
+(3281800, 9, 2, 0, 0, 0, 100, 513, 2000, 2000, 0, 0, 69, 0, 0, 0, 0, 0, 0, 20, 31442, 0, 0, 0, 0, 0, 0, 'Plump Turkey - Script - Move to Position'),
+(3281800, 9, 3, 0, 0, 0, 100, 513, 2000, 2000, 0, 0, 11, 61768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plump Turkey - Script - Cast Turkey Starts to Burn'),
+(3281800, 9, 4, 0, 0, 0, 100, 513, 2000, 2000, 0, 0, 11, 61769, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plump Turkey - Script - Cast Turkey Burns Up');
+
+UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE  `entry`=10717;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=10717;
+
+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
+(10717, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Temporal Parasite - On Just Summoned - Say'),
+(10717, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 70, 120, 0, 0, 0, 0, 0, 20, 175795, 0, 0, 0, 0, 0, 0, 'Temporal Parasite - On Just Summoned - Despawn Anorhal Silo Temporal Rift'),
+(10717, 0, 2, 0, 6, 0, 25, 0, 0, 0, 0, 0, 11, 16619, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Temporal Parasite - On Death - Cast Quest - Temporal Parasite Death Summon');
+
+UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE  `entry`IN(5307,5308);
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(5307,5308);
+
+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
+(5307, 0, 0, 0, 8, 0, 100, 0, 12699, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vale Screecher - On Spellhit - Despawn'),
+(5307, 0, 1, 0, 1, 0, 100, 0, 1000, 3000, 3000, 5000, 11, 59220, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Vale Screecher - IC - Cast Chain Lightning'),
+(5308, 0, 0, 0, 8, 0, 100, 0, 12699, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rogue Vale Screecher - On Spellhit - Despawn');