Mouth
Well-known member
I'm considering changing a User Upgrade that is currently Permanent to Annual (for length: 365 days) and affecting all current members of the usergroup.
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;
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?
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?