access membership details through mysql

Discussion in 'Customization & add-ons' started by philipps, Jan 18, 2013.

  1. philipps

    philipps New Member

    Joined:
    Jan 6, 2013
    Messages:
    13
    hi there,

    is there a way to access the details of a member (name, purchased products) directly through mysql?
    if so, what table do i have to query?

    i want to create a small php script and list the membership level / products of all members.

    thanks,
    phil
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Sure you can access these details.
    am_user - table which jols user's info
    am_access - table with holds user's active subscriptions.
    am_product - table which holds info about all products in the system.

Share This Page