RG Live WotLK 3.3.5a

https://git.rising-gods.de/wotlk/rg/commit/491b044dd7c306c4208cbdcd14750c676ad2be37

auf icc_merged nur erstmal. 8aktiv nach restart)

wird mit bestätigung direkt auf dem ptr eingespielt.

UPDATE creature_template SET dmg_multiplier = 109,5409 WHERE entry = 36626;
UPDATE creature_template SET dmg_multiplier = 153,3589 WHERE entry = 37504;
UPDATE creature_template SET dmg_multiplier = 153,3589 WHERE entry = 37505;
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 37506;

UPDATE creature_template SET dmg_multiplier = 199,3671 WHERE entry = 38550; -- 38550
UPDATE creature_template SET dmg_multiplier = 32,89127 WHERE entry = 38123; -- 38123
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 38549; -- 38549
UPDATE creature_template SET dmg_multiplier = 32,89127 WHERE entry = 36899; -- 36899
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 38390; -- 38390
UPDATE creature_template SET dmg_multiplier = 142,4051 WHERE entry = 36627; -- 36627

UPDATE creature_template SET dmg_multiplier = 128,1646 WHERE entry = 36678; -- 36678
UPDATE creature_template SET dmg_multiplier = 156,6456 WHERE entry = 38431; -- 38431
UPDATE creature_template SET dmg_multiplier = 156,6456 WHERE entry = 38585; -- 38585
UPDATE creature_template SET dmg_multiplier = 185,1266 WHERE entry = 38586; -- 38586

UPDATE creature_template SET dmg_multiplier = 142,4051 WHERE entry = 37970; -- 37970
UPDATE creature_template SET dmg_multiplier = 142,4051 WHERE entry = 37973; -- 37973
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 38400; -- 38400
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 38771; -- 38771
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 38401; -- 38401
UPDATE creature_template SET dmg_multiplier = 170,8861 WHERE entry = 38784; -- 38784
UPDATE creature_template SET dmg_multiplier = 242,0886 WHERE entry = 38785; -- 38785
UPDATE creature_template SET dmg_multiplier = 242,0886 WHERE entry = 38772; -- 38772

UPDATE creature_template SET dmg_multiplier = 107,5556 WHERE entry = 37955; -- 37955
UPDATE creature_template SET dmg_multiplier = 150,5778 WHERE entry = 38434; -- 38434
UPDATE creature_template SET dmg_multiplier = 150,5778 WHERE entry = 38435; -- 38435
UPDATE creature_template SET dmg_multiplier = 182,8445 WHERE entry = 38436; -- 38436

UPDATE creature_template SET dmg_multiplier = 128,1646 WHERE entry = 36612; -- 36612
UPDATE creature_template SET dmg_multiplier = 192,2469 WHERE entry = 37957; -- 37957
UPDATE creature_template SET dmg_multiplier = 192,2469 WHERE entry = 37958; -- 37958
UPDATE creature_template SET dmg_multiplier = 299,0507 WHERE entry = 37959; -- 37959

UPDATE creature_template SET dmg_multiplier = 104,5555 WHERE entry = 36855; -- 36855
UPDATE creature_template SET dmg_multiplier = 43,85503 WHERE entry = 37890; -- 37890
UPDATE creature_template SET dmg_multiplier = 21,59163 WHERE entry = 37949; -- 37949
UPDATE creature_template SET dmg_multiplier = 54,81879 WHERE entry = 38393; -- 38393
UPDATE creature_template SET dmg_multiplier = 53,97906 WHERE entry = 38394; -- 38394
UPDATE creature_template SET dmg_multiplier = 130,6944 WHERE entry = 38106; -- 38106

UPDATE creature_template SET dmg_multiplier = 128.1646 WHERE entry IN (36939, 36948, 38637, 38639);
UPDATE creature_template SET dmg_multiplier = 192.2469 WHERE entry IN (38156, 38157, 38638, 38640);

UPDATE creature_template SET `dmg_multiplier` = 98.220604159029 WHERE `entry` = 36853; -- Sindragosa
UPDATE creature_template SET `dmg_multiplier` = 152.7876064696 WHERE `entry` = 38265; -- Sindragosa (1)
UPDATE creature_template SET `dmg_multiplier` = 130.96080554537 WHERE `entry` = 38266; -- Sindragosa (2)
UPDATE creature_template SET `dmg_multiplier` = 240.09481016651 WHERE `entry` = 38267; -- Sindragosa (3)

Luftschiffadds. LK Valithria

Richtige Herowerte: Deathwhisper+Adds

UPDATE creature_template SET `dmg_multiplier` = 120.13389924186 WHERE `entry` = 38296; -- Lady Deathwhisper (2)
UPDATE creature_template SET `dmg_multiplier` = 220.24548194342 WHERE `entry` = 38297; -- Lady Deathwhisper (3)
UPDATE creature_template SET `dmg_multiplier` = 31.044064555024 WHERE `entry` = 38625; -- Cult Adherent (2)
UPDATE creature_template SET `dmg_multiplier` = 53,97906 WHERE `entry` = 38626; -- Cult Adherent (3)
UPDATE creature_template SET `dmg_multiplier` = 58.720433812184 WHERE `entry` = 38628; -- Cult Fanatic (2)
UPDATE creature_template SET `dmg_multiplier` = 83.886334017406 WHERE `entry` = 38629; -- Cult Fanatic (3)

Rushor Bitte für die entsprechenden dazugehörigen Adds anpassen.

TODO: Luftschiffadds. LK Valithria

Luftschiffadds:

Raketenschützen machen kein Meeleschaden.
Kriegsmagier auch nicht.
Axtwerfer auch nicht.
Es bleiben übrig:
Matrose der Himmelsbrecher & Häscher der Kor'kron
Unteroffizier der Himmelsbrecher & Unteroffizier der Kor'kron

UPDATE creature_template SET `dmg_multiplier` = 33.554533606963 WHERE `entry` = 36960; -- Kor'kron Sergeant
UPDATE creature_template SET `dmg_multiplier` = 33.554533606963 WHERE `entry` = 36961; -- Skybreaker Sergeant
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 36957; -- Kor'kron Reaver
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 36950; -- Skybreaker Marine
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38404; -- Kor'kron Reaver (1)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38262; -- Kor'kron Sergeant (1)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38406; -- Skybreaker Marine (1)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38261; -- Skybreaker Sergeant (1)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38691; -- Skybreaker Sergeant (2)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38692; -- Skybreaker Sergeant (3)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38685; -- Skybreaker Marine (2)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38686; -- Skybreaker Marine (3)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38679; -- Kor'kron Reaver (2)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38680; -- Kor'kron Reaver (3)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38683; -- Kor'kron Sergeant (2)
UPDATE creature_template SET `dmg_multiplier` = 41.943167008703 WHERE `entry` = 38684; -- Kor'kron Sergeant (3)

UPDATE creature_template SET `dmg_multiplier` = 73.665453119272 WHERE `entry` = 37698; -- Shambling Horror
UPDATE creature_template SET `dmg_multiplier` = 98.220604159029 WHERE `entry` = 39299; -- Shambling Horror (1)

UPDATE `creature_template` SET `dmg_multiplier` = 49.11 WHERE `entry` = 37886; -- Gluttonous Abomination
UPDATE `creature_template` SET `dmg_multiplier` = 44.249 WHERE `entry` = 37868; -- Risen Archmage
UPDATE `creature_template` SET `dmg_multiplier` = 27.327 WHERE `entry` = 37907; -- Rot Worm
UPDATE `creature_template` SET `dmg_multiplier` = 54.654 WHERE `entry` = 37934; -- Blistering Zombie
UPDATE `creature_template` SET `dmg_multiplier` = 20.568 WHERE `entry` = 36791; -- Blazing Skeleton

UPDATE `creature_template` SET `dmg_multiplier` = 61.949 WHERE `entry` = 38167; -- Risen Archmage (1)
UPDATE `creature_template` SET `dmg_multiplier` = 73.665 WHERE `entry` = 38166; -- Gluttonous Abomination (1)
UPDATE `creature_template` SET `dmg_multiplier` = 27.327 WHERE `entry` = 38168; -- Rot Worm (1)
UPDATE `creature_template` SET `dmg_multiplier` = 81.981 WHERE `entry` = 38170; -- Blistering Zombie (1)
UPDATE `creature_template` SET `dmg_multiplier` = 37.023 WHERE `entry` = 38169; -- Blazing Skeleton (1)

Bitte auch für Hero eintragen, da sind die Werte Katastrophal, und das ist ne Verbesserung. Bessere Werte kommen dann noch.

UPDATE `creature_template` SET `dmg_multiplier`=20.568 WHERE `entry`=38721;
UPDATE `creature_template` SET `dmg_multiplier`=37.023 WHERE `entry`=38722;
UPDATE `creature_template` SET `dmg_multiplier`=44.249 WHERE `entry`=38725;
UPDATE `creature_template` SET `dmg_multiplier`=61.949 WHERE `entry`=38735;
UPDATE `creature_template` SET `dmg_multiplier`=49.11 WHERE `entry`=38724;
UPDATE `creature_template` SET `dmg_multiplier`=73.665 WHERE `entry`=38734;
UPDATE `creature_template` SET `dmg_multiplier`=27.327 WHERE `entry`=38726;
UPDATE `creature_template` SET `dmg_multiplier`=27.327 WHERE `entry`=38736;
UPDATE `creature_template` SET `dmg_multiplier`=54.654 WHERE `entry`=38723;
UPDATE `creature_template` SET `dmg_multiplier`=81.981 WHERE `entry`=38733;

mal wieder updated - commit dann iwann vor release

UPDATE `creature_template` SET `dmg_multiplier` = 106.406 WHERE `entry` = 38433; -- Toravon the Ice Watcher
UPDATE `creature_template` SET `dmg_multiplier` = 147.331 WHERE `entry` = 38462; -- Toravon the Ice Watcher (1)

UPDATE `creature_template` SET `dmg_multiplier` = 147.331 WHERE `entry` = 36597; -- The Lich King

NPC_WICKED_SPIRIT = 39190,
boshafte geister - meleedamg zu gering - nur zur erinnerung :P

Bedeutung Live:

Der Bug wurde erfolgreich behoben und befindet sich auf dem Spielserver. Sollte der Fehler weiterhin bestehen sollte ein neues Ticket ( https://redmine.rising-gods.de/projects/live/issues/new ) erstellt werden. Anmerkungen in dem alten abgewiesenen oder live genommenen Ticket werden ignoriert und gelöscht.