Xenforo Report Improvements by Xon 2.14.16

Screenshots are still to be added, XF1 version has similar functionality and the screenshots

This add-on introduces potentially breaking changes to moderation permissions. Please review usergroup permissions carefully!

A Collection of improvements to XF's reporting system. Fully phrased.

On install, all existing warnings are copied into a new warning change tracking log and associated with reports. This process occurs as a background task, and is non-disruptive.

Note; when reports are sent to a forum, the warning<->report links can not be created!

Feature list:

• Improve performance of Report Center by reducing stock XenForo N+1 query behaviour
• Permission based access to the report center:
  • Default permissions set for groups (global/content) for groups with warn or edit basic profile permissions.
  • New Permissions:
    • View Report center
    • Comment on open report
    • Comment on closed report
    • Update a report's status
    • Assign report
    • See reporter username
• Sends an Alert to moderators who have commented/reported on a report.
  • Only sends an alert if the previous alert has not been viewed
  • Report Alerts link to the actual comments for longer reports
  • Report Alerts include the title of the report
• Alert moderators if a report is assigned to them
• Links Warnings to reports.
  • Visible from the warning itself, and when issuing warnings against content.
• Link reply bans to reports
  • Log reply bans into report system
  • Optional Issue a reply-ban on issuing a warning (default disabled)
  • Allow reply-banning through a closed threads for moderators
• Link Reports to Warnings.
  • Logs changes to Warnings (add/edit/delete), and associates them with a report.
• Automatically create a report for a warning.
• When issuing a Warning, option to resolve any linked report.
• Optional ability to log warnings into reports when they expire. This does not disrupt who the report was assigned to, and does not re-open the report.
• Report Comment Likes.
• Resolved Report Alerts are logged into Report Comments (as an explicit field).
• Search report comments
• Optional ability to search report comments by associated warning points, and warned user. (Requires Enhanced Search Improvements add-on)
• Reverse order of report comments (default disabled)
• Optional auto-reject/resolve sufficiently old reports (default disabled)
• Show content date when viewing a report
• Show forum for post reports in report list
• Permission-based ability to join a reported conversation

---

FAQ

Q. Performance is very slow when viewing a report
A. The query to find non-moderators who can be assigned permissions is somewhat expensive, especially for older versions of MySQL

1. Refresh the page and see if page performance improves after MySQL is no longer doing a cold start on the query.
2. Try doing "Clean up permission" from; AdminCP => Tools => Rebuild caches => "Clean up permission" & check "rebuild permissions"
3. Implement a XenForo cache provider so the results can be cached.
4. Upgrade MySQL to a later version, as later version handle the required subqueries much better.

Q. How are the new permissions setup by default
A. It setups up defaults based on how XenForo implicitly operates. The map is:

• View User Report
  • Warn/Edit Basic Profile
• View Post Report
  • Edit Any Post OR Delete Any Post for a user/group/forum
• View ProfilePost Report
  • Warn/Edit Any/Delete An
• View Conversation Report
  • Always Invite/Edit Any Post(in conversation)

Q. What options are there for configuring how report comments alerts are sent?
A. Configurable how report comments alerts are sent to moderators:

1. Alert all moderators.
2. Alert watchers on reply and all moderators for new alerts.
3. Alert watchers on reply (Default).