Assign active subscriber role to community moderators before billing

Your subscriber signups land without verified status, causing missed access and billing confusion. This gives subscription managers consistent access control and updated member rows before the next billing run.