mirror of
https://github.com/araxiaonline/ScourgeInvasion.git
synced 2026-06-13 03:02:21 -04:00
140 lines
13 KiB
SQL
140 lines
13 KiB
SQL
-- Spectral Apparition (16423)
|
|
|
|
DELETE FROM `creature_template` WHERE (`entry` = 16423);
|
|
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `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`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(16423, 0, 0, 0, 0, 0, 'Spectral Apparition', NULL, NULL, 0, 6, 7, 0, 1630, 0, 1.11111, 0.85714, 1, 1, 18, 1, 0, 0, 1, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 16423, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 100, 1, 8397332, 0, 0, '', 12340);
|
|
|
|
DELETE FROM `creature_template_model` WHERE (`CreatureID` = 16423);
|
|
INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
|
|
(16423, 0, 16169, 1, 1, 12340);
|
|
|
|
DELETE FROM `creature_template_spell` WHERE (`CreatureID` = 16423);
|
|
INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES
|
|
(16423, 0, 28265, 12340);
|
|
|
|
DELETE FROM `creature_questitem` WHERE (`CreatureEntry` = 16423);
|
|
INSERT INTO `creature_questitem` (`CreatureEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES
|
|
(16423, 0, 22892, 0);
|
|
|
|
DELETE FROM `creature_loot_template` WHERE (`Entry` = 16423);
|
|
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
|
|
(16423, 765, 0, 0.02, 0, 1, 0, 1, 1, 'Spectral Apparition - Silverleaf'),
|
|
(16423, 22892, 0, 35, 1, 1, 0, 1, 1, 'Spectral Apparition - Dim Necrotic Stone');
|
|
|
|
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 16423;
|
|
|
|
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 16423);
|
|
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`, `event_param5`, `event_param6`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
|
|
(16423, 0, 0, 0, 0, 0, 100, 0, 5000, 8000, 12000, 15000, 0, 0, 11, 28265, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Spectral Apparition - In Combat - Cast \'Scourge Strike\'');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Skeletal Soldier (16422)
|
|
DELETE FROM `creature_template` WHERE (`entry` = 16422);
|
|
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `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`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(16422, 0, 0, 0, 0, 0, 'Skeletal Soldier', NULL, NULL, 0, 6, 7, 0, 1630, 0, 1, 0.85714, 1, 1, 18, 1, 0, 0, 1, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 16422, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 100, 1, 8602129, 0, 0, '', 12340);
|
|
|
|
DELETE FROM `creature_template_spell` WHERE (`CreatureID` = 16422);
|
|
INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES
|
|
(16422, 0, 28265, 12340);
|
|
|
|
DELETE FROM `creature_questitem` WHERE (`CreatureEntry` = 16422);
|
|
INSERT INTO `creature_questitem` (`CreatureEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES
|
|
(16422, 0, 22892, 0);
|
|
|
|
DELETE FROM `creature_loot_template` WHERE (`Entry` = 16422);
|
|
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
|
|
(16422, 22892, 0, 35, 1, 1, 0, 1, 1, 'Skeletal Soldier - Dim Necrotic Stone'),
|
|
(16422, 22944, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16422, 22946, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16422, 22970, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16422, 22972, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16422, 22975, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16422, 22977, 0, 5, 0, 1, 0, 1, 1, '');
|
|
|
|
|
|
|
|
|
|
-- Bone Witch (16380)
|
|
DELETE FROM `creature_template` WHERE (`entry` = 16380);
|
|
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `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`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(16380, 0, 0, 0, 0, 0, 'Bone Witch', '', NULL, 0, 61, 61, 0, 1630, 0, 1, 1.14286, 1, 1, 20, 1, 4, 0, 1, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 16380, 0, 0, 0, 0, 0, 0, 'SmartAI', 1, 1, 2.5, 1, 1, 1, 0, 0, 1, 8585747, 0, 0, '', 12340);
|
|
|
|
DELETE FROM `creature_template_model` WHERE (`CreatureID` = 16380);
|
|
INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
|
|
(16380, 0, 16167, 1, 1, 12340);
|
|
|
|
|
|
DELETE FROM `creature_template_spell` WHERE (`CreatureID` = 16380);
|
|
INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES
|
|
(16380, 0, 13748, 12340),
|
|
(16380, 1, 17014, 12340),
|
|
(16380, 2, 28265, 12340);
|
|
|
|
DELETE FROM `creature_equip_template` WHERE (`CreatureID` = 16380);
|
|
INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES
|
|
(16380, 1, 0, 0, 0, 0);
|
|
|
|
DELETE FROM `creature_loot_template` WHERE (`Entry` = 16380);
|
|
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
|
|
(16380, 12841, 0, 35, 0, 1, 0, 1, 1, 'Bone Witch - Invader\'s Scourgestone'),
|
|
(16380, 22484, 0, 50.12, 0, 1, 0, 1, 1, 'Bone Witch - Necrotic Rune'),
|
|
(16380, 22944, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16380, 22946, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16380, 22970, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16380, 22972, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16380, 22975, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16380, 22977, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16380, 23090, 0, 20.68, 0, 1, 0, 1, 1, 'Bone Witch - Bracers of Undead Slaying'),
|
|
(16380, 23091, 0, 20.68, 0, 1, 0, 1, 1, 'Bone Witch - Bracers of Undead Cleansing'),
|
|
(16380, 23092, 0, 20.63, 0, 1, 0, 1, 1, 'Bone Witch - Wristguards of Undead Slaying'),
|
|
(16380, 23093, 0, 20.82, 0, 1, 0, 1, 1, 'Bone Witch - Wristwraps of Undead Slaying');
|
|
|
|
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 16380;
|
|
|
|
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 16380);
|
|
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`, `event_param5`, `event_param6`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
|
|
(16380, 0, 0, 0, 0, 0, 100, 0, 2000, 2000, 3000, 3000, 0, 0, 87, 1638001, 1638002, 1638003, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Bone Witch - In Combat - Run Random Script'),
|
|
(16380, 0, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 11, 20829, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Bone Witch - In Combat - Cast \'Arcane Bolt\''),
|
|
(16380, 0, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 11, 17014, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Bone Witch - In Combat - Cast \'Bone Shards\''),
|
|
(16380, 0, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 11, 56138, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Bone Witch - In Combat - Cast \'Sprained Ankle\'');
|
|
|
|
|
|
|
|
-- Spirit of the Damned (16379)
|
|
DELETE FROM `creature_template` WHERE (`entry` = 16379);
|
|
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `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`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(16379, 0, 0, 0, 0, 0, 'Spirit of the Damned', '', NULL, 0, 61, 61, 0, 1630, 0, 1, 1.14286, 1, 1, 20, 1, 4, 0, 1, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 16379, 0, 0, 0, 0, 0, 0, 'SmartAI', 1, 1, 2.5, 1, 1, 1, 0, 0, 1, 8413718, 0, 0, '', 12340);
|
|
|
|
DELETE FROM `creature_template_spell` WHERE (`CreatureID` = 16379);
|
|
INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES
|
|
(16379, 0, 34322, 12340),
|
|
(16379, 1, 16243, 12340),
|
|
(16379, 2, 28265, 12340);
|
|
|
|
DELETE FROM `creature_loot_template` WHERE (`Entry` = 16379);
|
|
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
|
|
(16379, 12841, 0, 35, 0, 1, 0, 1, 1, 'Spirit of the Damned - Invader\'s Scourgestone'),
|
|
(16379, 22484, 0, 57.06, 0, 1, 0, 1, 1, 'Spirit of the Damned - Necrotic Rune'),
|
|
(16379, 22944, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16379, 22946, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16379, 22970, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16379, 22972, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16379, 22975, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16379, 22977, 0, 5, 0, 1, 0, 1, 1, ''),
|
|
(16379, 23090, 0, 19.72, 0, 1, 0, 1, 1, 'Spirit of the Damned - Bracers of Undead Slaying'),
|
|
(16379, 23091, 0, 20.42, 0, 1, 0, 1, 1, 'Spirit of the Damned - Bracers of Undead Cleansing'),
|
|
(16379, 23092, 0, 18.74, 0, 1, 0, 1, 1, 'Spirit of the Damned - Wristguards of Undead Slaying'),
|
|
(16379, 23093, 0, 21.54, 0, 1, 0, 1, 1, 'Spirit of the Damned - Wristwraps of Undead Slaying');
|
|
|
|
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 16379;
|
|
|
|
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 16379);
|
|
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`, `event_param5`, `event_param6`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
|
|
(16379, 0, 0, 0, 0, 0, 100, 0, 4000, 15000, 15000, 25000, 0, 0, 11, 22743, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Spirit of the Damned - In Combat - Cast \'Ribbon of Souls\'');
|
|
|
|
|