Where is the membership type value stored?

Hello, I have along standing issue im desperately trying to solve on my website... 

HISTORY: I amusing OpenCart to process the transactions for my paid membership website(purely to avoid the heavy fees by PayPal etc) this however is run separately from dolphin (but on the same domain)and therefore when a member pays to upgrade their membership the database tables in dolphin remain unchanged - meaning they pay but don't get the upgrade! 

Problem: I have managed to find a combination of Javascript/Ajax and PHP coding which will solve this problem (using ajax to search the database to check if the payment was successful then using PHP code to change the value in the dolphin database table). however,

I cannot seem to gain access to the members profile information via PHPmyadmin in the server control panel, i can find the "Profiles" table but it only shows me the questions that are asked on sign up not the actual answers members have given.

In short I need to know which table (in dolphin 7.1) stores the value that defines what "membership type" each user/member is currently on?

I have found a table which specifies the original 3 membership types setup by dolphin but it doesnt show the two membership types i have created? (the ones i plan to use).

Any help at all on this subject would be a huge help! Thank you very very much in advance if you can help me with this :)

Just off top of my head, as I am not in front of the computer, I remember : sys_acl_levels_members

I had done something like this prior, but have not look into it since. The other issues you need to make sure you adjust for, is how you are going to keep track of which memberships are current and not, unless you are prorating all memberships to be due on a specific date and running a cron on that date and time.

Anyways.. Good luck


very true I actually hadn't got as far as thinking of monitoring the memberships for expirations! - Thank you for the heads up :)

I am actually inserting this script into the redirection page members are sent to once the payment is completed so its automated (in a sense). I will look into creating a script that i can run that will point out and change any expired memberships  to solve that issue.

I think you are correct with the tabe -  sys_acl_levels_members however i cannot seem to "expand" this table as it were to see the field and value definitions on each member - or any member information for that fact it simply states the three main membership types only :

Regards

Joe