fix attachments AJAX when friendly URLs are disabled
add a way to pass raw expressions to the SQL query builder
fix #124. the problem was that posts made at the same time could un-sync the conversation countPosts field (so it was 1 less than it should be.) so, to fix the sync issue on an existing forum, the upgrade script needs to be run. this can be done by enabling the Debug plugin and clicking "upgrade database" in its settings.
fix slow query in ETSession::isFlooding method. fixes #123
fix XSS vulnerability with conversation titles. closes #122
allow the use of "Administrator", "Moderator", and others as a username. closes #121
allow any characters in usernames
better transliteration in slugs. closes #120
fix avatars not displaying in member autocomplete menu. fixes #119
fix URL redirect stuff. closes #118 closes #105
changes to how sticky conversations are listed.
- they stick to the top for guests.
- a 200 character excerpt from the first post shows below them.
closes #117
Reading your own posts should not increase the view count. closes #116
Reduce sticky excerpt to 150 characters
make BBCode [code] block tag detection more reliable. closes #115
fix private conversation notifications including post content in the database entry. it should only be included as data for the email projection. closes #114 (hopefully)
Answers plugin: allow moderators/administrators to mark conversations as answered. closes #113
fix minor mobile header drop down menu aesthetic issue. closes #112
fix auto-linking bug for URLs containing parentheses. still not perfect but good enough. closes #111
better fix for <title> XSS. closes #108
AJAX for Reordering GET method changed to POST. couldn't merge automatically because didn't want the other commit, but thanks anyway! closes #106