Hey there!
We've created this add-on to help you solve the issue with emojis in XenForo v2.2.12. With it, you'll be able to keep using your emojis without any problem, even if you've had difficulties with them recently.
Thanks for using our add-on! Let us know if you have any questions.
leftspace89 submitted a new resource:
Add-on to Solve Emoji Issues in XenForo v2.2.12 - Our add-on helps you solve the issue with emojis in XenForo v2.2.12
Read more about this resource...
on member pages it doesn't bypass the csrf checks for and others with csrf token. xf resources and many. can you update addon for this? the lscache caches the xftoken value for visitors and csrf checks fails for guest visitors...
yes that else condition should be changed aswell. as a owner of code you would understand better and do better fixes.
right now Im using 1.6 version of this and I'll wait this fixes to applied on 1.7.5 for upgrade.
here's quick and dirty fix.
this bugfix reduces sql query time 4 seconds to 0.4 ms with 13k users banned.
https://gist.github.com/leftspace89/c934e42b71e55fb6c06cbeed19958057/revisions?diff=split
it will most likely do this when you have invalid user_id on xf_user_ban table
I did small modifications to sql queries here's my revision:
it works much faster now.
(still discouraged users panel slow cuz of COUNT query.) couldn't find a way to improve this.
https://gist.github.com/leftspace89/4829a40b5b9314d4b0e0df2687c37bde/revisions?diff=split