mirror of
https://github.com/araxiaonline/ScourgeInvasion.git
synced 2026-06-13 03:02:21 -04:00
99 lines
8.0 KiB
SQL
99 lines
8.0 KiB
SQL
-- Consolidated creature_template
|
|
DELETE FROM `creature_template` WHERE `entry` IN (14684, 14686, 14695, 28194, 14690, 14693, 14682);
|
|
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
|
|
(14684, 0, 0, 0, 0, 0, 'Balzaphon', NULL, NULL, 0, 60, 60, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14684, 0, 0, 0, 0, 2275, 2984, '', 0, 1, 6, 6, 1, 1, 0, 0, 1, 8405008, 0, 0, '', 12340),
|
|
(14686, 0, 0, 0, 0, 0, 'Lady Falther\'ess', NULL, NULL, 0, 37, 37, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 5, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14686, 0, 0, 0, 0, 208, 378, '', 0, 1, 8, 4, 1, 1, 0, 0, 1, 8405008, 0, 0, '', 12340),
|
|
(14695, 0, 0, 0, 0, 0, 'Lord Blackwood', NULL, NULL, 0, 60, 60, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14695, 0, 0, 0, 0, 1041, 1871, '', 0, 1, 10, 1, 1, 1, 0, 0, 1, 8388624, 0, 0, '', 12340),
|
|
(28194, 0, 0, 0, 0, 0, 'Prince Tenris Mirkblood', 'The San\'layn', '', 0, 70, 70, 1, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 2, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 8, 28194, 0, 0, 0, 0, 0, 0, '', 0, 1, 52.5, 10, 1, 1, 0, 176, 1, 8388624, 0, 0, '', 12340),
|
|
(14690, 0, 0, 0, 0, 0, 'Revanchion', NULL, NULL, 0, 60, 60, 0, 21, 0, 1.11111, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14690, 0, 0, 0, 0, 0, 0, '', 0, 1, 10, 2, 1, 1, 0, 0, 1, 8388624, 0, 0, '', 12340),
|
|
(14693, 0, 0, 0, 0, 0, 'Scorn', NULL, NULL, 0, 34, 34, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14693, 0, 0, 0, 0, 238, 657, 'SmartAI', 0, 1, 8, 6, 1, 1, 0, 0, 1, 8390928, 0, 0, '', 12340),
|
|
(14682, 0, 0, 0, 0, 0, 'Sever', NULL, NULL, 0, 21, 21, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14682, 0, 0, 0, 0, 64, 151, '', 0, 1, 9, 1, 1, 1, 0, 0, 1, 8388688, 0, 0, '', 12340);
|
|
|
|
|
|
-- Consolidated creature_template_model
|
|
DELETE FROM `creature_template_model` WHERE `CreatureID` IN (14684, 14686, 14695, 28194, 14690, 14693, 14682);
|
|
INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
|
|
(14684, 0, 7919, 1, 1, 12340),
|
|
(14686, 0, 10698, 1, 1, 12340),
|
|
(14695, 0, 14699, 1, 1, 12340),
|
|
(28194, 0, 25541, 1, 1, 12340),
|
|
(14690, 0, 14695, 1, 1, 12340),
|
|
(14693, 0, 16197, 1, 1, 12340),
|
|
(14682, 0, 1061, 1, 1, 12340);
|
|
|
|
|
|
-- Consolidated creature_template_spell
|
|
DELETE FROM `creature_template_spell` WHERE `CreatureID` IN (14684, 14690, 14682);
|
|
INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES
|
|
(14684, 0, 12096, 12340),
|
|
(14684, 1, 37265, 12340),
|
|
(14684, 2, 8398, 12340),
|
|
(14684, 3, 32370, 12340),
|
|
(14690, 0, 29849, 12340),
|
|
(14690, 1, 30267, 12340),
|
|
(14682, 0, 17745, 12340),
|
|
(14682, 1, 16508, 12340);
|
|
|
|
|
|
-- Consolidated creature_equip_template
|
|
DELETE FROM `creature_equip_template` WHERE `CreatureID` IN (14684, 14695);
|
|
INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES
|
|
(14684, 1, 13698, 0, 0, 18019),
|
|
(14695, 1, 18985, 12893, 5258, 18019);
|
|
|
|
|
|
-- Consolidated creature_loot_template
|
|
DELETE FROM `creature_loot_template` WHERE `Entry` IN (14684, 14686, 14695, 28194, 14690, 14693, 14682);
|
|
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
|
|
(14684, 12843, 0, 100, 0, 1, 0, 1, 1, 'Balzaphon - Corruptor''s Scourgestone'),
|
|
(14684, 14047, 0, 19, 0, 1, 0, 2, 4, 'Balzaphon - Runecloth'),
|
|
(14684, 23124, 0, 0, 0, 1, 1, 1, 1, 'Balzaphon - Staff of Balzaphon'),
|
|
(14684, 23125, 0, 0, 0, 1, 1, 1, 1, 'Balzaphon - Chains of the Lich'),
|
|
(14684, 23126, 0, 0, 0, 1, 1, 1, 1, 'Balzaphon - Waistband of Balzaphon'),
|
|
(14686, 23177, 0, 0, 0, 1, 1, 1, 1, 'Lady Falther''ess - Lady Falther''ess'' Finger'),
|
|
(14686, 23178, 0, 0, 0, 1, 1, 1, 1, 'Lady Falther''ess - Mantle of Lady Falther''ess'),
|
|
(14695, 12841, 0, 35, 0, 1, 0, 1, 1, 'Lord Blackwood - Invader''s Scourgestone'),
|
|
(14695, 23132, 0, 0, 0, 1, 1, 1, 1, 'Lord Blackwood - Lord Blackwood''s Blade'),
|
|
(14695, 23139, 0, 0, 0, 1, 1, 1, 1, 'Lord Blackwood - Lord Blackwood''s Buckler'),
|
|
(14695, 23156, 0, 0, 0, 1, 1, 1, 1, 'Lord Blackwood - Blackwood''s Thigh'),
|
|
(28194, 4113, 4113, 100, 0, 1, 0, 1, 1, 'Prince Tenris Mirkblood - (ReferenceTable)'),
|
|
(28194, 29434, 0, 100, 0, 1, 0, 2, 2, 'Prince Tenris Mirkblood - Badge of Justice'),
|
|
(28194, 38658, 0, 100, 0, 1, 0, 1, 1, 'Prince Tenris Mirkblood - Vampiric Batling'),
|
|
(28194, 39769, 0, 100, 0, 1, 0, 1, 1, 'Prince Tenris Mirkblood - Arcanite Ripper'),
|
|
(14690, 12843, 0, 100, 0, 1, 0, 1, 1, 'Revanchion - Corruptor''s Scourgestone'),
|
|
(14690, 23127, 0, 0, 0, 1, 1, 1, 1, 'Revanchion - Cloak of Revanchion'),
|
|
(14690, 23128, 0, 0, 0, 1, 1, 1, 1, 'Revanchion - The Shadow''s Grasp'),
|
|
(14690, 23129, 0, 0, 0, 1, 1, 1, 1, 'Revanchion - Bracers of Mending'),
|
|
(14693, 23168, 0, 0, 0, 1, 1, 1, 1, 'Scorn - Scorn''s Focal Dagger'),
|
|
(14693, 23169, 0, 0, 0, 1, 1, 1, 1, 'Scorn - Scorn''s Icy Choker'),
|
|
(14693, 23170, 0, 0, 0, 1, 1, 1, 1, 'Scorn - The Frozen Clutch'),
|
|
(14682, 23171, 0, 0, 0, 1, 1, 1, 1, 'Sever - The Axe of Severing'),
|
|
(14682, 23173, 0, 0, 0, 1, 1, 1, 1, 'Sever - Abomination Skin Leggings');
|
|
|
|
|
|
-- Consolidated creature
|
|
DELETE FROM `creature` WHERE `id1` IN (14684, 14686, 14695, 28194, 28194, 14690, 14693, 14682);
|
|
INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`, `CreateObject`, `Comment`) VALUES
|
|
(248654, 14684, 0, 0, 329, 2017, 2017, 1, 1, 0, 3733.27, -3480.11, 131.04, 3.05433, 7200, 0, 0, 14652, 14604, 0, 0, 0, 0, '', 46248, 0, NULL),
|
|
(248650, 14686, 0, 0, 129, 722, 722, 1, 1, 0, 2583.18, 695.861, 56.8033, 1.8675, 7200, 0, 0, 8744, 4568, 0, 0, 0, 0, '', 46248, 0, NULL),
|
|
(9999207, 14695, 0, 0, 289, 0, 0, 1, 1, 1, 257.816, 153.98, 109.757, 2.9985, 300, 0, 0, 36624, 0, 0, 0, 0, 0, '', NULL, 0, NULL),
|
|
(9999173, 28194, 0, 0, 0, 0, 0, 1, 1, 0, 2233.8, -5267.71, 76.0121, 3.45416, 300, 0, 0, 322765, 31550, 0, 0, 0, 0, '', NULL, 0, NULL),
|
|
(248651, 14690, 0, 0, 429, 2557, 2557, 1, 1, 0, -112.776, 583.823, -3.47887, 5.60251, 7200, 0, 0, 24420, 4868, 0, 0, 0, 0, '', 46248, 0, NULL),
|
|
(248652, 14693, 0, 0, 189, 796, 796, 1, 1, 0, 1797.84, 1233.68, 18.3153, 1.58286, 7200, 0, 0, 7104, 5610, 0, 0, 0, 0, '', 46248, 0, NULL),
|
|
(248653, 14682, 0, 0, 33, 209, 209, 1, 1, 0, -225.131, 2302.95, 94.7599, 6.02139, 7200, 0, 0, 4689, 0, 0, 0, 0, 0, '', 46248, 0, NULL);
|
|
|
|
|
|
-- Revanchion (14690) specific tables
|
|
DELETE FROM `creature_template_resistance` WHERE `CreatureID` = 14690;
|
|
INSERT INTO `creature_template_resistance` (`CreatureID`, `School`, `Resistance`, `VerifiedBuild`) VALUES
|
|
(14690, 2, 171, 12340),
|
|
(14690, 3, 171, 12340),
|
|
(14690, 4, 171, 12340),
|
|
(14690, 5, 171, 12340),
|
|
(14690, 6, 171, 12340);
|
|
|
|
|
|
DELETE FROM `creature_questitem` WHERE `CreatureEntry` = 14690;
|
|
INSERT INTO `creature_questitem` (`CreatureEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES
|
|
(14690, 0, 22224, 0);
|