Reading some relevant forum topics (eg. https://xenforo.com/community/threads/tricky-question-about-user-upgrades.102328/ and https://xenforo.com/community/threa...-it-still-demote-users-when-it-expires.46054/ ) I see that if I change the existing user upgrade it will not impact existing users - they'll remain as permanent.
So I'm thinking the current solution;
- Create a new user upgrade for my annual length (it will also be recurring payments)
- Disable the current permanent upgrade (untick 'Can be purchased')
- Run an SQL query that will set an expiry date for the existing permanent upgrade on all existing
Would the above solution work?
Thoughts on an appropriate SQL?
Is there any functionality to have a notice ( /admin.php?notices/ ) based on an upgrade expiring soon?