View Revisions: Issue #14311

Summary 0014311: Quaking affix algorithm not correct
Revision 2021-03-27 12:12 by Mirage24
Description 1) Bug description

The quaking algorithm on this server is: Do quaking every 20 seconds.
However, the algorithm instead should be: Every 20 seconds there is a chance of quaking.


2) Proof: Official server video

Example video from official server: https://youtu.be/26fm5wxVhCI?t=63
(Note that timestamps are not the actual video timestamps but remaining time for the dungeon timer.)

Quaking at 34:10 dungeon timer remaining
Quaking at 33:50 dungeon timer remaining
No quaking at 33:30 dungeon timer remaiing
Quaking at 33:10 dungeon timer remaining

In this example you can see that a quaking had the chance to happen at 33:30 but it did not happen.


3) Proof: Argusx100 video

To show that quaking has a 100% rate on this server, here is the first part of an Argusx100 Cathedral key: https://www.youtube.com/watch?v=cLzKD6I3qwo

These are the timestamps (remaining timer) for quaking. You see that it happens every 20 seconds.
34:40
34:20
34:00
33:40
33:20
33:00
32:40
32:10 (+2 deaths)
31:45 (+1 death)
31:25
31:05
30:45
30:25
30:05
29:45


4) Correct Algorithm

What is the chance of quaking to be triggered on the official server at 7.3.5?

I haven't found a documentation. What I did instead was to collect warcraftlogs.

I've picked 17 logs containing the quaking affix with the following requirements to make the research easier:
- The player has not died during the dungeon (as a dead player can't have quaking debuff)
- The dungeon does not contain scripted sequences where quaking is never triggered

Then I did the following math:

How many seconds does the dungeon last? Example: 1459 seconds
How many "20 second" intervals does it have? Example: 1459 / 20 = 72,95 => Take Math.Floor => 72
How many quakings did appear? Example: 55
=> The avg. quaking rate is 55/72 => 76%


For all 17 logs the avg. quaking rate turned out 77%

I understand that 77% might not be the real chance of quaking as 17 examples is still a pretty low amount, but the real chance must at least be close to 77%.

Therefore I suggest to change the current quaking algorithm from "Do quaking every 20 seconds" to "Every 20 seconds there is a (close to number 77)% chance of quaking to be triggered"

Here is the warcraftlogs data I've used.

The format is:

Link
Player name
Total dungeon time in seconds
Number of 20 sec intervals
Number of Quakings
Quaking average (Number of quakings / number of 20 sec intervals)



https://www.warcraftlogs.com/reports/qTzYcv3DHpZQy9BJ#fight=1&type=auras&spells=debuffs&ability=240447&source=1
Stom
1459
72
55
0.7639


https://www.warcraftlogs.com/reports/MWvcbmt61hDVPH3T#fight=1&type=auras&spells=debuffs&ability=240447&source=1
Quanti
1624
81
59
0.7284


https://www.warcraftlogs.com/reports/DJ2ZFb9vfcP6a3RN#fight=2&type=auras&spells=debuffs&ability=240447&source=2
Littlealby
832
41
32
0.7805


https://www.warcraftlogs.com/reports/qVW8zwZnbx4amL13#fight=1&type=auras&spells=debuffs&ability=240447&source=1
Padadave
1148
57
45
0.7895


https://www.warcraftlogs.com/reports/H1RcMK8fvnDqQb3g#fight=3&type=auras&spells=debuffs&ability=240447&source=75
Анава
1193
59
40
0.6780


https://www.warcraftlogs.com/reports/L9d2FZj34ytqNHYw#fight=33&type=auras&source=12&spells=debuffs&ability=240447
Dotsnothot
812
40
33
0.8250


https://www.warcraftlogs.com/reports/X3HT1ZV4fWJdarM6#fight=1&type=auras&source=4&spells=debuffs&ability=240447
Deathnahcz
1204
60
47
0.7833


https://www.warcraftlogs.com/reports/B9f8KM43QA6v1jLy#fight=2&type=auras&source=2&spells=debuffs&ability=240447
Merajin
1307
65
51
0.7846


https://www.warcraftlogs.com/reports/fk7Kavrzm3b62FGP#fight=34&type=auras&source=3&spells=debuffs&ability=240447
Trif
1199
59
43
0.7288


https://www.warcraftlogs.com/reports/B9f8KM43QA6v1jLy#fight=3&type=auras&source=2&spells=debuffs&ability=240447
Merajin
1461
73
62
0.8493


https://www.warcraftlogs.com/reports/AvQwP9XxYNL6bt8M#fight=22&type=auras&source=18&spells=debuffs&ability=240447
Klaps
1558
77
60
0.7792


https://www.warcraftlogs.com/reports/FykjDYpKPmxBdTf9#fight=5&type=auras&source=2&spells=debuffs&ability=240447
Nishizumi
1060
53
41
0.7736


https://www.warcraftlogs.com/reports/8KBt1AJry4a6jhbk#fight=8&type=auras&source=4&spells=debuffs&ability=240447
Baseddhunter
1143
57
46
0.8070


https://www.warcraftlogs.com/reports/haH1JRvDFnPcz7Qj#fight=33&type=auras&source=69&spells=debuffs&ability=240447
Shabooke
1036
51
37
0.7255


https://www.warcraftlogs.com/reports/ygGh8W1vTMJXk6bL#fight=1&type=auras&source=4&spells=debuffs&ability=240447
Crescentsoul
1157
57
45
0.7895


https://www.warcraftlogs.com/reports/GmdZ7fNhPvnT8Qxy#fight=3&type=auras&source=146&spells=debuffs&ability=240447
Fortyseven
1214
60
49
0.8167


https://www.warcraftlogs.com/reports/caRyvmMwbrHA2XnD#fight=26&type=auras&source=15&spells=debuffs&ability=240447
Psicosi
1373
68
41
0.6029
Revision 2021-03-24 17:39 by Sulphos
Description 1) Bug description

The quaking algorithm on this server is: Do quaking every 20 seconds.
However, the algorithm instead should be: Every 20 seconds there is a chance of quaking.


2) Proof: Official server video

Example video from official server: https://youtu.be/26fm5wxVhCI?t=63
(Note that timestamps are not the actual video timestamps but remaining time for the dungeon timer.)

Quaking at 34:10 dungeon timer remaining
Quaking at 33:50 dungeon timer remaining
No quaking at 33:30 dungeon timer remaiing
Quaking at 33:10 dungeon timer remaining

In this example you can see that a quaking had the chance to happen at 33:30 but it did not happen.


3) Proof: Argusx100 video

To show that quaking has a 100% rate on this server, here is the first part of an Argusx100 Cathedral key: https://www.youtube.com/watch?v=cLzKD6I3qwo

These are the timestamps (remaining timer) for quaking. You see that it happens every 20 seconds.
34:40
34:20
34:00
33:40
33:20
33:00
32:40
32:10 (+2 deaths)
31:45 (+1 death)
31:25
31:05
30:45
30:25
30:05
29:45


4) Correct Algorithm

What is the chance of quaking to be triggered on the official server at 7.3.5?

I haven't found a documentation. What I did instead was to collect warcraftlogs.

I've picked 17 logs containing the quaking affix with the following requirements to make the research easier:
- The player has not died during the dungeon (as a dead player can't have quaking debuff)
- The dungeon does not contain scripted sequences where quaking is never triggered

Then I did the following math:

How many seconds does the dungeon last? Example: 1459 seconds
How many "20 second" intervals does it have? Example: 1459 / 20 = 72,95 => Take Math.Floor => 72
How many quakings did appear? Example: 55
=> The avg. quaking rate is 55/72 => 76%


For all 17 logs the avg. quaking rate turned out 77%

I understand that 77% might not be the real chance of quaking as 17 examples is still a pretty low amount, but the real chance must at least be close to 77%.

Therefore I suggest to change the current quaking algorithm from "Do quaking every 20 seconds" to "Every 20 seconds there is a (close to number 77)% chance of quaking to be triggered"