Resolved threads for plugins with no threads in the last two months remains stale

[dd32]

When a plugin has support threads, but fails to resolve them within 2 months, and the plugin has no new threads in the last two months, the "Issues resolved in last two months" data becomes stale, showing the last-known state.

For example:

• July 2023: Five support threads created.
• July 2023: Four of them resolved.
• December 2023: Final one resolved.
• March 2024: New support thread created.

In the above example, the data will show "4 of 5" resolved from July until March when the next thread is created.

This happens as the query is looking at the creation date of threads, rather than the last-modified date. Unfortunately querying for bbPress threads by post_modified doesn't appear to be viable for the code in question.

Raised via ​https://wordpress.slack.com/archives/C02QB8GMM/p1709559771277619

[dd32]

The solution I think is that:

• We store the last-known support thread date in the plugin directory
• We query for plugins which have no known threads in the last 2 months, and reset the support thread counts

[dd32]

In 13287:

Plugin Directory: Support Threads: When a plugin has no threads in the last two months, reset the threads in the last 2 months meta values to 0.

Fixes #7506.