Jump to content

Recommended Posts

  • 39 years later...
Posted

22

2

7644

Who has been writing this patch? Please include either forum user names or email addresses.

Seizer

As source of info: Wowwiki, elitistjerks, retail forums, existing values in tables, comments from various sites, omen, official

Patch:

DELETE FROM spell_threat WHERE entry IN (48470, 676, 6673, 5242, 6192, 11549, 11550, 11551, 25289, 47436, 2048, 47520, 47519, 469, 47439, 47440, 47437, 25203, 25202, 11555, 11554, 6190, 1160, 47497, 47498, 845, 7369, 11608, 11609, 47449, 47450, 57823, 72, 47487, 47488, 47467, 47501, 47502, 99, 1735, 9490, 9747, 9898, 26998, 48559, 48560, 48475, 48567, 48568, 6807, 6808, 6809, 8972, 9745, 9880, 9881, 26996, 48479, 48480);
INSERT INTO spell_threat VALUES
(25289, 62),
(11551, 56),
(11550, 48),
(11549, 40),
(6192, 32),
(5242, 26),
(6673, 18),
(2048, 70),
(47436, 78),
(47440, 80),
(47439, 60),
(469, 40),
(47437, 63),
(25203, 55),
(25202, 50),
(11555, 37),
(11554, 30),
(6190, 26),
(1160, 16),
(47520, 225),
(47519, 180),
(11609, 70),
(11608, 60),
(7369, 40),
(845, 10),
(47497, 101),
(47498, 101),
(676, 104),
(47450, 259),
(47449, 236),
(57823, 500),
(72, 293),
(47488, 770),
(47487, 520),
(47467, 345),
(47502, 260),
(47501, 235),
(48480, 322),
(48470, 322),
(26996, 322),
(9881, 322),
(9880, 322),
(9745, 322),
(8972, 322),
(6809, 322),
(6808, 322),
(6807, 322),
(99, 42),
(1735, 42),
(9490, 42),
(9747, 42),
(9898, 42),
(26998, 42),
(48559, 42),
(48560, 42),
(48475, 130),
(48567, 285),
(48568, 285);

Update, added druid spells (The ones which were missing threat values, and some which have had them wrong. Tested in official with omen threat meter.)

Posted

Added druid spell's threats also (tested with omen in off)

without these, tanking is very hard, if not impossible..

can a moderator change this threads title to

"[spell_threat, SQL] corrections"

?

these affect on many spells on how they work.. like all ranks of faerie fire should pull the enemy, but atm only 1 rank does it..

  • 2 weeks later...
Posted
2 Tested in official with omen threat meter.)

Does Omen use the blizzard supplied data post 3.0 ?

If it doesn't: Omen used to only create a rough guess via regression instead of having correct values.

  • 7 months later...
Posted

hm... 47498 in mangos.sql not have all ranks (with your data also :( )

7386 and ranks not have fixed threat and 58567 must be called with scalled effect 1 value, so need fix in another thread. I add instead drop all related old ranks.

Typo in spell id (48470, 322), expected 48479

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use