Database field locations

Reading posts and using phpMyAdmin, I was able to find the database fields for part of the S2Member database but the fields such as: Role Custom Capabilities Registration Date First Payment Date Last Payment Date Auto-EOT Date Custom Value Paid Subscr. ID Paid Subscr. Gateway seem to be somewhere I cannot find.

I have written an application to deliver content to users through a private messaging system based on their subscription / membership information, so I need to be able to access more fields than just the base WP fields.

How can I access the necessary fields? Where are they kept? and what other info might be helpful to accessing these files

thanks

Thank you for your inquiry.

I’d recommend using this function for gathering this data:

http://www.s2member.com/codex/stable/s2member/api_functions/package-functions/#src_doc_get_user_field()