xF1 Alert Improvements by Xon

[ven0m]

Heisenberg submitted a new resource:

You must be registered for see links

- A collection of minor improvements to the XenForo Alerts system.

A collection of improvements to the XenForo Alerts system.

Features

• For threads/conversation/profile pages, automatically marks alerts as read from content on a given page when viewed.
• Mark unread link for individual alerts on the Alerts page.
• Supports the following add-ons:
  • Post Ratings.
  • Conversation Improvements.
  • Report Improvements.

Performance impact

• 1 extra query per thread page request when the user has more than...

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Prevent an SQL error if the user has 65535 alerts and marks another alert as unread.
• When marking alerts as read on a page, do a select first to determine how many alerts are still unread.
  • This is intent to reduce rows locked when doing the UPDATE.
  • If splitting of read/writes is done, this will allow the slave servers to be checked for any outstanding alerts instead of hitting the master.
• Support PREVENT_MARK_READ debug option

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Show mark as unread link for recently read alerts

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Prevent rare deadlock when viewing a thread page when the viewing user has unread alerts from that page.

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

Support marking alerts as read for the following add-ons:

• Post Rating
• Conversation Improvements
• Report Improvements

Improved thread handling, so when new posts are viewed on replying to clicking the 'show more posts' link, and relevant alerts are marked as read.

Minor tweaks to reduce the risk of deadlocks when marking alerts as read.

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Ajaxify the "Mark Unread" link

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

On viewing a thread sometimes a deadlock occurs when updating the alert total, if so now retry once.

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• When viewing a user's profile page, mark any relevant alerts from that page as read.
• Add a "mark all as read" link to the alerts page.
• Allow users to not mark-as-read all alerts when viewing account/alerts page, setting is on account/preferences page.
  • Instead of requiring knowledge of the non-documented "skip_mark_read" argument for the same functionality

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Prevent an SQL error if the user has 65535 alerts and marks another alert as unread.
• When marking alerts as read on a page, do a select first to determine how many alerts are still unread.
  • This is intent to reduce rows locked when doing the UPDATE.
  • If splitting of read/writes is done, this will allow the slave servers to be checked for any outstanding alerts instead of hitting the master.
• Support PREVENT_MARK_READ debug option

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Simplify SQL that marks alerts as read when viewing content.

You must be registered for see links