PoliceDog

This addon is aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single forum. Smaller forum do not gain much benefit from this add-on. Member List/Forum/conversation lists: MySQL implements 'early row lookup', when combined with LIMIT & OFFSET with a large offset, results in the large select statement pulling in more data than is required. Maybe one day MySQL will fix this. Maybe. This causes an issue as this how conversations and threads implement paging. This addon provides some optimized query for getting threads in a forum with large number of threads, or for conversations with a very high page count. Ideally conversations would implement the position system like posts do, which would be even faster than using sub-selects to force 'late row lookup'. For more information see: http://stackoverflow.com/questions/4481388/why-does-mysql-higher-limit-offset-slow-the-query-down http://explainextended.com/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/ Configuration Under "Performance":

Displayed per-thread banners above the editor to users who can post Features: Displays in both Quick Reply, and preview reply views. Only fetches the thread reply banner when viewing a thread that can be replied to. Text may be up to 65536 characters long, and supports bbcode. Logs modifications of these banners to the Moderator Logs. Edit history for banner New Permission to control who can manage and see reply banners. View Thread Reply Banner - default - to users/groups who can reply. Manage Thread Reply Banner - default - to users/groups who can delete/edit all posts, or warn.