My users come in through a subscription in woocommerce on a wordpress site. Once they have an active subscription I add them manually to XenForo. (Not perfect... but that automation part can come later).
My custom wordpress plugin updates the their user records (wp_usermeta) with a active subscription flag based on the woocommerce subscription status.
What I need to do is make an api call to my script on the wordpress site (could be direct sql as both are on the same server) to check if the user has an active subscription (or not) every time they login.
I'm a php pro with 15 years of experience, so I'll be comfortable coding what's needed.
I'm just 3 days old in XenForo, so please could someone point me in the right direction Where do I start looking ?
Thanks & Regards
P.S Apologies if this is posted in the wrong place.