Initial rework for Wailing Caverns

[ghost]

TABLE: creature

-- Wailing Caverns:

-- Change placement and orientation for Skum:
UPDATE creature SET position_x = '-280.561401', position_y = '-311.043488', position_z = '-69.488785', orientation = '0.644256' WHERE guid = '87131';

-- Remove Faulty Spawns:
DELETE FROM creature WHERE guid IN (26225, 38113, 85958, 87126);

-- Correct Faulty/Bugged Spawns:
UPDATE creature SET position_x = '-68.485260', position_y = '-144.390793', position_z = '-79.300156', orientation = '2.611722' WHERE guid = '52598'; -- Deviate Shambler (ID 5761)
UPDATE creature SET position_x = '-92.714462', position_y = '-134.856400', position_z = '-79.199921', orientation = '6.006601' WHERE guid = '85900'; -- Evolving Ectoplasm (ID 3640)

-- Spawn Distance adjustments:
-- 15-rane (used for select critters):
UPDATE creature SET spawndist=15, MovementType=1 WHERE guid IN (38145, 87154);
-- 10-range:
UPDATE creature SET spawndist=10, MovementType=1 WHERE guid IN (33964, 33957, 33932, 45722, 85901, 38121);
-- 7-range:
UPDATE creature SET spawndist=7, MovementType=1 WHERE guid IN (33946, 33987, 85919, 85965, 86137, 86013, 87143, 87156, 18682, 26203, 38147);
-- 6-range:
UPDATE creature SET spawndist=6, MovementType=1 WHERE guid IN (33956, 85959, 18679, 18681, 18680);
-- 0 (DISABLE):
UPDATE creature SET spawndist=0, MovementType=0 WHERE guid IN (85948);

-- Spawn Position Adjustments:
UPDATE creature SET position_x = '-65.732407', position_y = '-29.630383', position_z = '-60.038757', orientation = '4.021506' WHERE guid = '33976'; -- Druid of the Fang(ID 3840)
UPDATE creature SET position_x = '-72.367798', position_y = '-37.318535', position_z = '-59.850075', orientation = '0.899550' WHERE guid = '45718'; -- Druid of the Fang(ID 3840)
UPDATE creature SET position_x = '-291.516815', position_y = '-213.751236', position_z = '-63.036900', orientation = '4.702846' WHERE guid = '87142'; -- Druid of the Fang(ID 3840)
UPDATE creature SET position_x = '-215.064392', position_y = '-328.235962', position_z = '-71.043266', orientation = '2.019011' WHERE guid = '87125'; -- Druid of the Fang(ID 3840)

-- Spawn Distance Adjustments to already spawned lashers:
UPDATE creature SET spawndist=6, MovementType=1 WHERE guid IN (18686, 18683, 18684, 18685, 33980, 33981, 33982, 38126, 38120, 38132, 38127, 45721, 48752, 85920, 85916, 85912, 85917, 85918, 85989, 87112, 85988, 87111, 87110, 87106, 87109, 87103, 87098, 87102, 87101, 87097, 86104, 87120, 87119, 87118, 87135, 87137, 87138, 87136, 87151, 87149, 87152, 87148);

-- Critter Adjustments:
UPDATE creature SET spawndist=15, MovementType=1 WHERE guid=38135, 38125, 33985, 33978, 33979, 18677, 26219, 26238, 26215, 26222, 26226, 26201, 26222, 26238, 27358, 27358, 27347, 27370, 27373, 27377, 33937, 33968, 33953, 33940);
UPDATE creature SET position_x = '17.817574', position_y = '435.634857', position_z = '-81.148735', orientation = '3.737468' WHERE guid = '33937'; -- Snake (ID 2914)
UPDATE creature SET position_x = '-70.924637', position_y = '371.368103', position_z = '-105.181313', orientation = '5.058896' WHERE guid = '27370';
UPDATE creature SET position_x = '-23.271814', position_y = '132.678024', position_z = '-106.161560', orientation = '1.518708' WHERE guid = '26219'; -- (Bile Toad 3835)

TABLE: creature_template

 -- Disciple of Naralex, gossip text. (Pre-Awakening Ritual)
UPDATE creature_template SET GossipMenuId  = '201' WHERE entry='3678';

-- Stats for all creatures in Wailing Cavers
-- Deviate Adder:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 45,
    MaxMeleeDmg = 63,
    MinLevelHealth = 1251,
    MaxLevelHealth = 1347
WHERE entry='5048';
-- Deviate Crocolisk:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 26,
    MaxMeleeDmg = 37,
    MinLevelHealth = 417,
    MaxLevelHealth = 449
WHERE entry='5053';
-- Deviate Dreadfang:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 47,
    MaxMeleeDmg = 63,
    MinLevelHealth = 1347,
    MaxLevelHealth = 1347
WHERE entry='5056';
-- Deviate Guardian:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 45, 
    MaxMeleeDmg = 63,
    MinLevelHealth = 1251,
    MaxLevelHealth = 1347
WHERE entry='3637';
-- Deviate Lasher:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 32, 
    MaxMeleeDmg = 42,
    MinLevelHealth = 134,
    MaxLevelHealth = 134
WHERE entry='5055';
-- Deviate Moccasin: 
UPDATE creature_template SET 
    Armor  = 748,
    MinMeleeDmg = 47,
    MaxMeleeDmg = 63,
    MinLevelHealth = 1347, 
    MaxLevelHealth = 1347
WHERE entry='5762';
-- Deviate Python:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 26,
    MaxMeleeDmg = 37,
    MinLevelHealth = 167,
    MaxLevelHealth = 180
WHERE entry='8886';
-- Deviate Ravager:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 45, 
    MaxMeleeDmg = 63,
    MinLevelHealth = 1251,
    MaxLevelHealth = 1347
WHERE entry='3636';
-- Deviate Shambler:
UPDATE creature_template SET 
    Armor  = 683,
    MinMeleeDmg = 44,
    MaxMeleeDmg = 58,
    MinLevelMana = 456, 
    MaxLevelMana = 456, 
    MinLevelHealth = 1212, 
    MaxLevelHealth = 1212
WHERE entry='5761';
-- Deviate Slayer:
UPDATE creature_template SET 
    Armor  = 748,
    MinMeleeDmg = 23,
    MaxMeleeDmg = 33,
    MinLevelHealth = 356, 
    MaxLevelHealth = 386
WHERE entry='3633';
-- Deviate Venomwing:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 47,
    MaxMeleeDmg = 63,
    MinLevelHealth = 1347,
    MaxLevelHealth = 1347
WHERE entry='5756';
-- Deviate Viper:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 47, 
    MaxMeleeDmg = 63,
    MinLevelHealth = 1122, 
    MaxLevelHealth = 1122
WHERE entry='5755';
-- Druid of the Fang:
UPDATE creature_template SET 
    Armor  = 683,
    MinMeleeDmg = 44, 
    MaxMeleeDmg = 58,
    MinLevelMana = 912, 
    MaxLevelMana = 912, 
    MinLevelHealth = 1212, 
    MaxLevelHealth = 1212
WHERE entry='3840';

-- Stats for Bosses in Wailing Caverns:
-- Kresh:
UPDATE creature_template SET 
    Armor  = 4140,
    MinMeleeDmg = 50,
    MaxMeleeDmg = 66,
    MinLevelHealth = 1452,
    MaxLevelHealth = 1452
WHERE entry='3653';
-- Deviate Faerie Dragon:
UPDATE creature_template SET 
    Armor  = 817,
    MinMeleeDmg = 47,
    MaxMeleeDmg = 63,
    MinLevelHealth = 1347,
    MaxLevelHealth = 1347
WHERE entry='5912';
-- Lady Anacondra:
UPDATE creature_template SET 
    Armor  = 712,
    MinMeleeDmg = 68,
    MaxMeleeDmg = 91,
    MinLevelMana = 490, 
    MaxLevelMana = 490,     
    MinLevelHealth =  2165,
    MaxLevelHealth = 2165
WHERE entry='3671';
-- Lord Cobrahn:
UPDATE creature_template SET 
    Armor  = 712,
    MinMeleeDmg = 68, 
    MaxMeleeDmg = 91,
    MinLevelMana = 490, 
    MaxLevelMana = 490,         
    MinLevelHealth = 2165,
    MaxLevelHealth = 2165
WHERE entry='3669';
-- Lord Pythas:
UPDATE creature_template SET 
    Armor  = 712,
    MinMeleeDmg = 78, 
    MaxMeleeDmg = 104,
    MinLevelMana = 490, 
    MaxLevelMana = 490,     
    MinLevelHealth = 2165,
    MaxLevelHealth = 2165
WHERE entry='3670';
-- Lord Sepentis:
UPDATE creature_template SET 
    Armor  = 712,
    MinMeleeDmg = 78,
    MaxMeleeDmg = 104,
    MinLevelMana = 1470, 
    MaxLevelMana = 1470,            
    MinLevelHealth = 2598,
    MaxLevelHealth = 2598
WHERE entry='3673';
-- Mutanus the Devourer:
UPDATE creature_template SET 
    Armor  = 852,
    MinMeleeDmg = 70,
    MaxMeleeDmg = 94,
    MinLevelHealth = 3872,
    MaxLevelHealth = 3872
WHERE entry='3654';
-- Skum:
UPDATE creature_template SET 
    Armor  = 852,
    MinMeleeDmg = 59, 
    MaxMeleeDmg = 78, 
    MinLevelHealth = 3630,
    MaxLevelHealth = 3630
WHERE entry='3674';
-- Verdan the Everliving:
UPDATE creature_template SET 
    Armor  = 852,
    MinMeleeDmg = 277,
    MaxMeleeDmg = 369,
    MinLevelHealth = 3872,
    MaxLevelHealth = 3872
WHERE entry='5775';

NOTE:

• There is a lot of adjustments to spawn distance because it was currently incorrect or lacking. I used retail as a visual reference and tried my best to get it visually as close as possible to how it behaves on the live servers.
• Source for stat-adjustments is the World of WarCraft bestiary.
• I understand it will be very cumbersome to confirm the validity of the changes made to creature movement and spawn positions so it's understandable that you discard the proposed changes in favor of something that provides more reference to intended behaviour and is better documented. Perhaps major rework like this is better suited to contributors who you can rely on their work based of off the quality of their previous work.

[Neotmiren]

It is essential to know what is game patch the "World of Warcraft bestiary" relates to?

Verdan the Everliving has Health=3872 and this value matches to TBC and WotLK DBs (HGC-DB and YTDB, specifically). But there is possibility that his Classic health was higher (4167 in old SDB and current ClassicDB). It is common case, there are many creatures with slightly reduced health in later patches.

On the other hand, melee damage 277-369 from L21 Elite creature seems something extreme and interesting. Related wowhead comments:

"He hits VERY hard, much harder than any other boss inside Wailing Caverns. He doesn't have an overwhelming amount of hit points though"

"This boss hits hard and has a vast amount of hitpoints"

"Hits for around 144 on a lvl 21 tank with 40% physical reduction and had demo shout up".

"...the tank was dead while i was casting to heal. Our tank died like after 3 hits."

So 277-369 might be true. But also maybe it might be not so much, 116-208 (TBC HGC-DB). Anyway, current ClassicDB 101-130 is too low, without doubt.

In place of Cala I would accept this patch in its "guaranteed aspects" - when it makes creatures stronger, because Blizzard only nerfed things in course of time. Position changes are also likely to be true, even if taken from post-Classic patches, but only up to WotLK, not from Cataclysm and later - you could be more specific about the source of these observations.

[ghost]

Interesting points regarding the validity of stats and the possible causes for deviation(e.g. if there is a reduction in a certain patch). Perhaps we could try to document this on the forums or somewhere it's easily accessible?

[Neotmiren]

Very good place to document various subjects is https://github.com/cmangos/issues/wiki

But it requires certain amount of energy and intent to document something (with some degree of quality).

[ghost]

I would go out on a limb and say that GitHub's wiki format doesn't really encourage discussions. If it worked like Wikipedia where we could attach a "talk" section to the various topics as well then I would agree.

edit: accidentally managed to press "close and comment".

[Neotmiren]

You are right, but on the other hand forums are bad place for document something.

[cala]

Fixes pushed in recent commits (from this issue and backports from UDB). The creature stats update will come later. I let the issue open in the meantime.

[Tobschinski]

Your will, my hands.

[cala]

I was thinking of doing it myself but if you like to go to the coal mine, feel free to do it. :wink: