DB/Creatures: added missing default creature_template_difficulty entries for bruteforced creatures

1 files changed, 134 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_08_17_01_world.sql b/sql/updates/world/cata_classic/2024_08_17_01_world.sql
new file mode 100644
index 00000000000..30c3161c51a
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_17_01_world.sql
@@ -0,0 +1,134 @@
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=0 AND `Entry` IN (228792,228668,228667,228666,228379,228378,228377,228376,228375,228374,227495,226581,226201,225965,224065,223475,222858,222854,219985,219981,219980,219977,219976,218794,218747,213605,212241,211340,211332,211299,211297,211026,211025,211012,211011,209074,209070,208033,207489,207484,207128,206762,206038,205999,205998,205997,205958,205890,205838,202935,201106,200900,200848,199649,199411,199387,198934,198901,198875,198706,198525,196534,196503,194870,194795,192218,189739,186207,185664,185560,185404,185403,185401,185400,185336,185335,185334,185333,185332,185331,185317,184837,184263,184262,184261,184260,184259,181760,181684,181670,181485,180982,180757,179017,178858,178449,178420,177659,177297,177064,176708,176663,176553,176552,176547,176546,176525,176490,176443,176437,174404,173758,173754,173338,169106,168834,168833,166359,162539,36792,33351,26671,25537,25406,25323,24699,24695,24693,24692,19714,19711,17733));
+INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES
+(228792, 0, 3, 9, 7, 0, 1048640, 0), -- Magmaw Spike Stalker
+(228668, 0, 0, 1, 1, 0, 134217728, 0), -- Glorious Conquest Vendor
+(228667, 0, 0, 1, 1, 0, 134217728, 0), -- Conquest Vendor
+(228666, 0, 0, 1, 1, 0, 134217728, 0), -- Honor Vendor
+(228379, 0, 0, 1, 1, 0, 134217728, 0), -- Weapons Vendor
+(228378, 0, 0, 1, 1, 0, 134217728, 0), -- Plate Armor Vendor
+(228377, 0, 0, 1, 1, 0, 134217728, 0), -- Mail Armor Vendor
+(228376, 0, 0, 1, 1, 0, 134217728, 0), -- Leather Armor Vendor
+(228375, 0, 0, 1, 1, 0, 134217728, 0), -- Cloth Armor Vendor
+(228374, 0, 0, 1, 1, 0, 134217728, 0), -- Accessories Vendor
+(227495, 0, 0, 1, 1, 0, 0, 0), -- (DNT) Invisible Stalker
+(226581, 0, 0, 1, 1, 0, 0, 0), -- Wind Rider
+(226201, 0, 0, 1, 1, 0, 0, 0), -- Peletort
+(225965, 0, 0, 1, 1, 0, 134217728, 0), -- Frix Xizzix
+(224065, 0, 0, 1, 1, 0, 0, 0), -- Swoopy
+(223475, 0, 0, 1, 1, 0, 1091568640, 0), -- [DND] Goblin Town-in-a-Box Bunny
+(222858, 0, 0, 1, 1, 0, 0, 0), -- Pinchy the Plunderer
+(222854, 0, 2, 1, 1, 0, 0, 0), -- Polly Roger
+(219985, 0, 0, 1, 1, 0, 134217728, 0), -- Kazz Fizzledink
+(219981, 0, 0, 1, 1, 0, 134217728, 0), -- Moxie Woolpuller
+(219980, 0, 0, 1, 1, 0, 134217728, 0), -- Razik Chumpchanger
+(219977, 0, 0, 1, 1, 0, 134217728, 0), -- Clank Coppernozzle
+(219976, 0, 0, 1, 1, 0, 134217728, 0), -- Clink Coppernozzle
+(218794, 0, 0, 1, 1, 0, 134217728, 0), -- Blitz Skuzzweaver
+(218747, 0, 0, 1, 1, 0, 134217728, 0), -- Elle Arcspark
+(213605, 0, 0, 1, 1, 0, 0, 0), -- Arfus
+(212241, 0, 0, 1, 1, 0, 0, 0), -- Peletort
+(211340, 0, 2, 1, 1, 0, 0, 0), -- Kolara Dreamsmasher
+(211332, 0, 2, 1, 1, 0, 0, 0), -- Korralin Hoperender
+(211299, 0, 2, 10, 10, 0, 0, 0), -- Sunreaver Warden
+(211297, 0, 2, 10, 10, 0, 0, 0), -- Silver Covenant Warden
+(211026, 0, 2, 1, 1, 0, 0, 0), -- Avatar of Flame
+(211025, 0, 0, 1, 1, 0, 0, 0), -- Lil' Wrathion
+(211012, 0, 0, 1, 1, 0, 0, 0), -- Cypress
+(211011, 0, 2, 1, 1, 0, 0, 0), -- Auspicious Arborwyrm
+(209074, 0, 1, 1, 1, 0, 1024, 0), -- Northrend Daily Dungeon Roll Bunny 2
+(209070, 0, 1, 1, 1, 0, 1024, 0), -- Northrend Daily Dungeon Roll Bunny 1
+(208033, 0, 2, 1, 1, 0, 0, 0), -- Nightmarish Emerald Drake
+(207489, 0, 2, 10, 1, 0, 108, 0), -- [DNT] Dark Essence
+(207484, 0, 2, 10, 1, 0, 108, 0), -- [DNT] Light Essence
+(207128, 0, 2, 1, 1, 0, 0, 0), -- Animated Constellation
+(206762, 0, 2, 0.008999999612569808, 1, 0, 8, 0), -- Nerub'ar Spiderling
+(206038, 0, 2, 15, 1, 0, 72, 0), -- Immortal Crusher Tentacle
+(205999, 0, 2, 0.009999999776482582, 1, 0, 16777216, 0), -- Mirror Image
+(205998, 0, 2, 0.009999999776482582, 1, 0, 16777216, 0), -- Mirror Image
+(205997, 0, 2, 0.009999999776482582, 1, 0, 16777216, 0), -- Mirror Image
+(205958, 0, 2, 25, 1, 0, 0, 0), -- Zombie Horror
+(205890, 0, 2, 1, 1, 0, 134217728, 0), -- Zidormi
+(205838, 0, 2, 4, 1, 0, 16777216, 0), -- Anub'ar Webweaver
+(202935, 0, 0, 1, 1, 0, 0, 8), -- Elder Clearwater
+(201106, 0, 2, 4, 5, 0, 8, 0), -- Plague Master
+(200900, 0, 0, 1, 1, 0, 0, 0), -- Glub
+(200848, 0, 0, 1, 1, 0, 0, 0), -- Celestial Steed
+(199649, 0, 2, 1, 1, 0, 4096, 0), -- Crafted Gearataur
+(199411, 0, 2, 1, 1, 0, 4096, 0), -- Dungeon Gearataur
+(199387, 0, 2, 1, 1, 0, 4096, 0), -- D3-BA
+(198934, 0, 2, 568.343017578125, 35, 0, 134217740, 0), -- [DNT] Image of Thrall
+(198901, 0, 2, 1, 1, 0, 134217728, 0), -- Zidormi
+(198875, 0, 2, 7, 1, 0, 134217728, 0), -- Thassarian
+(198706, 0, 2, 0.009999999776482582, 1, 0, 16777216, 0), -- Mirror Image
+(198525, 0, 2, 1, 1, 0, 0, 0), -- Festering Emerald Drake
+(196534, 0, 0, 1, 1, 0, 0, 0), -- Hoplet
+(196503, 0, 2, 1, 1, 0, 0, 0), -- Hao-Yue, River Foreseer
+(194870, 0, 0, 1, 1, 0, 134217728, 0), -- Pebble
+(194795, 0, 0, 1, 1, 0, 134217728, 0), -- Fishspeaker Irtusk
+(192218, 0, 2, 8, 2000, 0, 0, 0), -- QA Test Dummy 80 Spell Spammer 2
+(189739, 0, 2, 1, 1, 0, 0, 0), -- Kalu'ak Whalebone Glider
+(186207, 0, 0, 1.35000002384185791, 1, 0, 135266304, 0), -- Invisible Bunny
+(185664, 0, 1, 1, 1, 0, 134217728, 0), -- Razorsaw Transform (Magnetic Mode)
+(185560, 0, 0, 1, 1, 0, 134217728, 0), -- Satyr Vision
+(185404, 0, 0, 1.049999952316284179, 1, 0, 134217728, 0), -- Relathor Moonsong
+(185403, 0, 0, 1.049999952316284179, 1, 0, 134217728, 0), -- Cyriden Farseeker
+(185401, 0, 0, 1, 1, 0, 134217728, 0), -- Elodrius
+(185400, 0, 0, 1, 1, 0, 134217728, 0), -- Talarian
+(185336, 0, 0, 1.149999976158142089, 1, 0, 134217728, 0), -- Jezelle's Incubus
+(185335, 0, 0, 1, 1, 0, 134217728, 0), -- Summoned Incubus
+(185334, 0, 0, 1.019999980926513671, 1, 0, 134217728, 0), -- Isaac Pearson
+(185333, 0, 0, 1.019999980926513671, 1, 0, 134217728, 0), -- Avelina Lilly
+(185332, 0, 0, 1, 1, 0, 134217728, 0), -- Isaac Pearson Projection
+(185331, 0, 0, 1, 1, 0, 134217728, 0), -- Avelina Lilly Projection
+(185317, 0, 2, 1, 0.769999980926513671, 0, 134217728, 0), -- Incubus
+(184837, 0, 1, 6, 1, 0, 134217736, 0), -- Zealous Consort Transform Visual
+(184263, 0, 1, 8, 1, 0, 134217736, 0), -- Zealous Consort
+(184262, 0, 1, 6, 1, 0, 134217736, 0), -- Wanton Host Transform Visual
+(184261, 0, 1, 8, 1, 0, 134217736, 0), -- Wanton Host
+(184260, 0, 1, 6, 1, 0, 134217736, 0), -- Night Lord Transform Visual
+(184259, 0, 1, 8, 1, 0, 134217736, 0), -- Night Lord
+(181760, 0, 1, 1, 1, 0, 1209008144, 6), -- Arena Bulletin Board
+(181684, 0, 0, 1, 1, 0, 134217728, 0), -- [DND] TAR Pedestal - Armor, Resistance
+(181670, 0, 0, 1, 1, 0, 134217728, 0), -- Resistance Armor Vendor
+(181485, 0, 0, 1, 1, 0, 134217728, 0), -- Flurky
+(180982, 0, 1, 2.75, 1, 0, 134217728, 0), -- Atrejo's Test Creature
+(180757, 0, 0, 1.35000002384185791, 1, 0, 1024, 0), -- Leap Target
+(179017, 0, 0, 10000, 1, 0, 134217728, 8192), -- Raid Buffer
+(178858, 0, 0, 1, 1, 0, 134217728, 0), -- Captain Placeholder
+(178449, 0, 0, 2406, 1, 0, 134217729, 0), -- Generic Hunter Pet
+(178420, 0, 1, 1, 1, 0, 134217728, 0), -- Magister Astalor Bloodsworn
+(177659, 0, 0, 10000, 1, 0, 134217728, 8192), -- Boss Dummy
+(177297, 0, 0, 1400, 1, 0, 134217728, 0), -- Nexus-Lord Donjon Rade Jr.
+(177064, 0, 0, 10000, 47.92499923706054687, 0, 134217728, 0), -- Spellcaster Dummy
+(176708, 0, 0, 1, 1, 0, 134217728, 0), -- Reawakened Phase-Hunter
+(176663, 0, 0, 1.35000002384185791, 1, 0, 134217728, 0), -- Call for Help Trigger
+(176553, 0, 0, 1.35000002384185791, 1, 0, 134217728, 0), -- Stormwind
+(176552, 0, 0, 1.35000002384185791, 1, 0, 134217728, 0), -- Orgrimmar
+(176547, 0, 0, 1.35000002384185791, 1, 0, 134217728, 0), -- Call for Help Trigger
+(176546, 0, 0, 1.35000002384185791, 1, 0, 134217728, 0), -- Call for Help Trigger
+(176525, 0, 0, 175, 150, 0, 134217804, 128), -- The Prophet Skeram
+(176490, 0, 0, 175, 150, 0, 134217804, 128), -- The Prophet Skeram
+(176443, 0, -1, 10000, 1, 0, 134217728, 8192), -- Dummy
+(176437, 0, 0, 1.35000002384185791, 1, 0, 134217728, 0), -- Heigan Aggro Trigger
+(174404, 0, 0, 1.35000002384185791, 1, 0, 135266304, 0), -- Invisible Bunny
+(173758, 0, 0, 1.35000002384185791, 1, 0, 135266304, 0), -- Overlord Runthak
+(173754, 0, 0, 1.35000002384185791, 1, 0, 135266304, 0), -- Major Mattingly
+(173338, 0, 0, 1.35000002384185791, 1, 0, 135266304, 0), -- Invisible Bunny
+(169106, 0, 0, 1, 1, 0, 134217728, 0), -- Shea Dorrisist
+(168834, 0, 0, 1, 1, 0, 134217728, 0), -- Phlas Kanfrost
+(168833, 0, 0, 1, 1, 0, 134217728, 0), -- Nate Yurisist
+(166359, 0, 0, 3, 1, 0, 134217737, 0), -- Zulian Tiger
+(162539, 0, 0, 1.25, 1, 0, 134217728, 0), -- World Talent Master
+(36792, 0, 2, 30, 1, 0, 2048, 0), -- [PH] Unused Quarry Overseer
+(33351, 0, 2, 55, 10, 0, 4, 0), -- Morgan Test
+(26671, 0, 2, 4, 1, 0, 0, 0), -- Rabid Dire Bear *Unused*
+(25537, 0, 0, 1, 1, 0, 134217728, 0), -- Craig's Test Human A
+(25406, 0, 0, 2, 2, 0, 4608, 0), -- Craig Steele2
+(25323, 0, 0, 2, 1, 0, 4608, 0), -- Craig Steele
+(24699, 0, 1, 3, 5, 0, 134217736, 0), -- [UNUSED] Sargeron Trickster
+(24695, 0, 1, 2.90000009536743164, 5, 0, 134217736, 0), -- [UNUSED] Nether Shade
+(24693, 0, 1, 2.90000009536743164, 5, 0, 134217736, 0), -- [UNUSED] Arcane Nightmare
+(24692, 0, 1, 2.90000009536743164, 5, 0, 134217736, 0), -- [UNUSED] Brightscale Serpent
+(19714, 0, 1, 3, 1, 0, 134217728, 0), -- Mechanar Pulverizer (UNUSED)
+(19711, 0, 1, 3, 1, 0, 134217728, 0), -- Mechanar Ripper (UNUSED)
+(17733, 0, 0, 1, 1, 0, 134217736, 0); -- [UNUSED] Lykul Larva