Vomissure !

DELETE FROM `creature_template` WHERE entry = 28301;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
(28301, 0, 0, 0, 0, 0, 328, 0, 0, 0, 'ZP - Retch! Bunny', '', '', 0, 1, 1, 0, 2023, 0, 1, 1.14286, 1, 0, 0, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 128, '', 12340);


DELETE FROM `smart_scripts` WHERE `entryorguid` = 28301 AND source_type = 0;
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
(28301, 0, 0, 0, 60, 0, 100, 0, 1000, 1000, 1000, 1000, 11, 43963, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'UPDATE - CAST - SELF Bunny cast Vomi !'),
(28301, 0, 1, 0, 54, 0, 100, 1, 0, 0, 0, 0, 11, 51241, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'JUST_SUMMONED - CAST - SELF Bunny cast ZP - Retch! (Bunny Aura)'),
(28301, 0, 2, 0, 60, 0, 100, 0, 1000, 1000, 2000, 2000, 11, 57523, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'UPDATE - CAST - SELF Bunny cast Zombie décharné soigneur'),
(28301, 0, 3, 0, 60, 0, 100, 1, 16000, 16000, 0, 0, 51, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'UPDATE - KILL_UNIT - SELF Bunny kill self'),
(28301, 0, 4, 0, 10, 0, 100, 0, 0, 15, 1000, 1000, 75, 43958, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'OOC_LOS - ADD_AURA - ACTION_INVOKER Bunny add aura spell Vous êtes infecté !');


DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` IN (28301);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 5, 28301, 0, 0, 1, 0, 43958, 0, 0, 1, 0, 0, '', 'Execute the SAI if target has not aura 43958'),
(22, 5, 28301, 0, 0, 1, 0, 43869, 0, 0, 1, 0, 0, '', 'Execute the SAI if target has not aura 43869');