Forum, topic, and reply counts alongside pending topics and replies

[netweb]

Migrating here from the originally reported issue raised in ​#meta1140

[netweb]

In ​[bbPress5870]:

Tests: Add topic voice count test test_bbp_get_topic_voice_count_with_pending_reply().

This test tests the voice count of a topic to ensure replies with post status pending are not included in the voice count until approved.

[netweb]

In ​[bbPress5871]:

Tests: Add forum last active id test test_bbp_get_forum_last_active_id_with_pending_reply().

This test tests the forums last active id to ensure replies with post status pending are not used as the forums last active id until the reply is approved.

[netweb]

The ​2838-tests-01.diff patch is the first in a series of failing unit tests that should pass to resolve this ticket.

This patch covers bbp_get_topic_freshness_link() and the following reply actions:

• bbp_trashed_reply()
• bbp_untrashed_reply()
• bbp_spammed_reply()
• bbp_unspammed_reply()
• bbp_approved_reply()
• bbp_unapproved_reply()

[netweb]

In 5880:

Replies: In bbp_update_reply_walker() always update the topics last active time with bbp_update_topic_last_active_time() regardless of reply's published status.

This changeset including unit tests ensures that when calling reply actions spam/unspam, trash/untrash, approve/unapprove the reply's parent topic's last active time is updated to the time of the last published reply.

Props netweb. See #2838

[johnjamesjacoby]

Assigning all closed & unassigned tickets in the 2.6 milestone to myself.

[johnjamesjacoby]

Still seeing this as an issue, specifically when topics & replies hit moderation and are marked as Pending.

[johnjamesjacoby]

Assigning to self, needs patch (will upload soon...)

[johnjamesjacoby]

Somewhat difficult to understand from a single screenshot, but here's the topic description showing that the JJJ user (Keymaster) replied to a Pending Topic (one of the +2 hidden ones.)

Somewhat of an edgewise, but I don't feel like any replies to a pending topic should bump the counts or the last activity time, at least until the topic is approved.

[johnjamesjacoby]

In 6923:

Counts (meta-data): full audit of forum/topic/reply, public/non-public counts.

This commit is the result of a full count audit, exposing multiple inconsistencies and voids in relation to how public and non-public counts are (re)calculated.

For instance, hidden forum replies are not counted at all, until now. By introducing a new Repair tool, hidden forum reply counts are now counted.

In addition, there were multiple bugs with topic & reply moderation, where the act of approving or unapproving topics or replies would cause the numbers to be inaccurate, or where topics & replies being caught in moderation were still increasing public counts.

It was also possible to, as a Key Master, publicly reply to unapproved topics, which was a completely unanticipated side-effect of allowing Key Masters to do pretty much anything. Going forward, the default reply status is the topic status, but is still beholden to all existing moderation settings and user role capabilities. This results in a more sane user experience, and prevents the unusual circumstance of there being "0 topics and 30 replies" in public-facing forums.

Certain count increase/decrease actions have been reprioritized to avoid collisions and race conditions, proving once again that ya gotta get up to get down.

See #2838. Fixes #1799.