database table

Hi,
I would like to let my members to buy a pro service version that lasts 12 months.

I wonder how I could find member's status on the DB.

The pro service is access through web services so I need to know the table structure and which info are available.

For example:
1. Could I find the expire date of each member?
2. member plan (basic/pro)

Thanks in advance,
Stefano

Hi Stefano

The easiest way would be query database directly to get the data you want. All the subscription related data (plan_id, subscription start date, subscription end date, first name, last name... are stored in the table #__osmembership_subscribers) and you can easily query that table to get the data you need

Tuan

Hi,
I just brought Payment Form because I saw an example with a membership plan (6, 9, 12 months)
here .

Where can I found on the database the expire of the membership?

Thanks in advance
Stefano

Hi Stefano

Unfortunately, Payment Form could not be used to handle Membership. If you need to handle Membership, please purchase Membership Pro instead

I am going to check and refund your payment form purchase later today

Tuan

Hi Tuan,
I checked Membership Pro ouand it suites my needs.

I am going to purchaise it. Are you able to refund my previous payment?

Regards.
Stefano

Hi Stefano

Yes, of course. Please purchase Membership Pro extension and submit a support ticket joomdonation.com/support-tickets.html let me know PayPal Transaction ID of your Payment Form purchase. I will process the refund

Regards,

Tuan