Report Improvements by Xon 2.21.3

• Add indexes to improve user delete/merge performance for xf_report/xf_report_comment/xf_sv_warning_log tables

• Fix unexpected additional queries for non-moderators when viewing a thread when Show 'post has open report' banner on posts for moderators feature is enabled

• Require StandardLib v1.22.0+
• Improve XF cloud compatibility
• Fix possible error when viewing report search results
• Fix displaying points for a deleted warning in the reports comments
• Display non-embedded attachments when viewing a report
• When issuing a warning with a forum ban via Forum reply ban to a post, the recorded report is attributed to the post and not the user's profile
• Add "Show 'post has open report' banner on posts for moderators" option (default: true)
• Backport XF2.3.4 fix for "Resolved report alert not sent if report assigned and unassigned"

• Compatibility fix when using \XF\Db\ReplicationAdapter and a report is resolved/rejected

• Fix a report's content could sometimes be loaded multiple times instead of just once
• Fix excessive memory usage when viewing a report when many content moderators exist

• Fix post report view permission check would fail if the original forum the report was generated from was deleted
• Fix approval queue 'report content' feature did not check the content was viewable before checking if the content could be reported.
• Fix unexpected approval queue rebuilds when it isn't required.

• Fix displaying points for a deleted warning in the reports comments
• Fix approval queue counts would be recomputed every time the approval queue was viewed
• Fix reports would be incorrectly fetched when recomputing approval queue counts
• Fix N+1 query behavior when adding reports to approval queue items

• Fix incorrect phrase usage for direct messages with XF2.3
• When viewing a report, show a 'user info tab' by default instead of a list of warnings to avoid page jank & excessive scrolling

• Display warnings/warning actions (Warning Improvements)/member notes (@Z61's Member Notes addon) for the reported user when viewing a report
• Add "svSearchImprov_search_container.report" phrase for better phrasing support on Advanced search page

Bugfix Update

• Fix possible XF2.3 error on report notifications