What's new

Elwynn Forest creature/duplicates fixes | MoP 5.4.8

eltnen

Gold Supporter
Verified Member
12
2023
7
Location
Netherlands
After running through Elwynn Forest I noticed several duplicate mobs and issues and made sure to write down the fixes I did in the database on my server.
I will update this post if I add any more for Elwynn Forest.

----- 2023-06-30 -----
Duplicate mob removal (254 records):
SQL:
DELETE FROM mop_world.creature WHERE guid IN (180373, 180179, 180426, 177808, 180190, 180036, 180443, 177285, 177367, 177759, 179989, 177752, 177363, 180360, 179831, 179907, 180103, 180207, 179922, 177875, 177831, 179885, 180069, 178320, 179674, 178140, 179713, 180386, 915420, 180012, 179742, 179741, 179814, 180048, 179867, 179986, 180362, 180045, 179800, 179799, 180429, 179620, 179968, 180315, 180155, 180196, 180171, 180358, 180173, 177763, 180442, 180197, 180177, 180298, 179798, 180428, 179893, 180002, 180180, 179897, 180104, 180169, 180154, 180314, 180006, 179732, 179508, 179992, 180176, 180159, 179977, 179964, 180175, 179991, 179585, 180153, 179584, 919427, 919492, 179583, 180236, 179954, 179669, 179649, 180395, 179647, 179577, 179990, 180004, 180038, 179795, 180118, 180018, 179623, 180338, 179671, 179756, 179762, 179676, 179739, 180403, 180375, 179752, 179763, 178260, 180389, 915357, 180385, 177811, 180427, 180192, 180450, 179899, 180028, 180188, 180026, 178454, 180014, 180009, 180399, 180011, 178373, 178642, 177358, 177742, 177546, 177769, 177409, 177566, 177414, 177714, 180157, 180327, 180166, 177361, 180352, 177418, 177844, 177360, 177746, 177725, 180163, 180348, 177507, 180165, 177359, 180182, 177576, 180160, 180158, 180143, 177715, 177700, 180328, 180291, 179797, 928796, 177740, 180256, 177628, 180123, 177460, 177506, 180356, 177749, 177704, 180152, 180218, 180394, 180305, 180470, 177865, 177825, 177836, 177807, 214871, 177839, 215002, 177526, 180336, 180392, 180239, 180409, 180432, 180393, 177580, 180410, 215004, 177827, 177862, 177723, 177826, 177835, 180184, 177862, 180027, 177830, 178371, 179883, 178699, 178700, 178742, 178734, 178805, 178797, 178817, 178763, 178828, 178765, 178674, 178803, 178109, 178159, 178819, 302900, 178801, 179320, 179344, 178906, 178903, 179199, 179198, 179330, 179326, 179327, 178912, 178921, 179331, 178907, 178920, 178896, 178909, 178905, 179317, 178919, 179332, 178883, 178918, 178989, 178857, 179476, 178881, 179717, 179415, 179621, 179850, 179426, 179429, 179427, 179423, 179648, 177578, 302508, 215000);

Narg the Taskmaster damage reduction (rare mob)
SQL:
UPDATE `mop_world`.`creature_template` SET `dmg_multiplier` = '3.7' WHERE (`entry` = '79');

Gruff Swiftbite damage reduction (rare mob)
SQL:
 UPDATE `mop_world`.`creature_template` SET `dmg_multiplier` = '4.2' WHERE (`entry` = '100');
 
Top