I'm trying to find out in what mySQL table and what row does amember store product id to which user is currently subscribed. I need that so I could write simple custom code to Wordpress to offer users, who are already subscribed to a certain product, to upgrade their membership to a higher level. So let's say user signs up for Silver membership (id = 1) and logs in to his membership area (I use Wordpress as my CMS). And when he does a simple script is activated, connecting to amember's DB, checking if he should be offered an upgrade to GOLD membership... In other words it should be something like this... if ($subscribed_product_id == 1) { echo "Upgrade your membership"; } else { echo "You are already GOLDEN member"; } ...hope that makes sense
check the mysql.inc.php file. I believe the function you want is: global $db; $db->get_user_active_payments($member_id, date('Y-m-d')); look at the check_subscriptions function to see how it is used.