diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_08_17_01_world.sql | 134 |
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 |