Community Support Forums — WordPress® ( Users Helping Users ) — 2011-11-30T10:33:34-05:00 http://www.primothemes.com/forums/feed.php?f=4&t=16118 2011-11-30T10:33:34-05:00 http://www.primothemes.com/forums/viewtopic.php?t=16118&p=54239#p54239 <![CDATA[Re: SQL query to access specific s2member information of use]]>
Could someone please answer my queries? This is quite crucial for my site to live :)

thank you.

Regards
Arpana

Statistics: Posted by Arpana — November 30th, 2011, 10:33 am

]]> 2011-11-29T11:00:48-05:00 http://www.primothemes.com/forums/viewtopic.php?t=16118&p=54198#p54198 <![CDATA[SQL query to access specific s2member information of users]]>
I am struggling to get the correct SQL query to access s2member information, given a user id. Could you please help me with the following questions:
(1) What is the SQL query to retrive the current access level of the user, given any one of the user's info: a) user name b) user id or c) user email
(2) What is the output value format?
(3) Which table is this information stored and against which reference (is it stored per uid/username/ etc)?

Thank you.
Regards
Arpana

Statistics: Posted by Arpana — November 29th, 2011, 11:00 am

]]>