I'm trying to tell if a user account is active or not, outside of WP code, by looking at the database only. Seems like a bad practice for sure, but I'm kinda stuck in this situation and anyway, it seems interesting to me to know for sure how WP determines this.
After searching in the documentation and in the questions/answers, I couldn't find anything clear.
What I observed from the database is :
- every active user has a "PREFIX_capabilities" row in "PREFIX_usermeta"
- every pending account has a "activation_key" row in "PREFIX_usermeta"
Which indicator should I use to determine if the account is active ? Seems to me that both are equivalent, but I'm not sure this is deterministic...
Could someone please confirm this or correct me if I'm wrong ?
Thanks a lot for any advice, All the best,