I look into amember database and amember_members table. There is a column "status" with value 0 or 1 or 2 So what is 0 mean? what is 1 mean? what is 2 mean? Please let me know. Thanks
first, I have to say that this value is for read only. Changing this value alone is useless and will cause troubles. 0 - pending (user has no active subscriptions) 1 - active (user has at least one active subscriptions) 2 - expired (all user subscriptions are expired, and there can be some pending)
The reason I asked is that, I have an external database that hold my members profile. And the members profiles are listing on our website. What I want to do is this If amember_members.status is expired or pending. Then that particular profile will not displaying. So My SQL code is like this: PHP: $query_rstNewModels = "SELECT * FROM v2models.tb_models, v2members.amember_members WHERE tb_models.member_id = amember_members.member_id AND amember_members.status='1' AND tb_models.yearofbirth <= $levelage AND tb_models.active= '1' ORDER BY tb_models.model_id DESC"; Now, I want only member with status active based on amembers status How do I do that?