Viewing Auto EOT using ODBC Connection

[rglick]

How do I view Auto EOT and Membership levels when connecting to S2Member tables using an ODBC connection.

[Cristián Lávaque]

There aren't s2Member tables, the data is stored in WP's tables like usermeta.

[rglick]

Any information on how this can be displayed and edited outside of Wordpress. I have a database program (Filemaker Pro) connected to the MySQL tables. The WP_Users table for example is easily viewable and editable however the S2 member data cannot. The Filemaker solution is much better buited for my back office staff to modify and report on the data. Thoughts on how to make this happen?

[Cristián Lávaque]

s2Member stores some of its data in serialized arrays, like in the usermeta table. You'd need to unserialize the data to view it correctly. http://php.net/unserialize

I hope that helps.