- 12
- 2023
- 10
- 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):
Narg the Taskmaster damage reduction (rare mob)
Gruff Swiftbite damage reduction (rare mob)
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');