Support

  1. davidunwin
  2. Support
  3. Saturday, January 30 2021, 03:33 PM
  4.  Subscribe via email
We use Membership Pro
https://joomdonation.com/joomla-extensions/membership-pro-joomla-membership-subscription.html
When a user register for Membership Pro, their profile is added to Easy Profile.
Each Membership Pro is allocated a Plan Name and id (see attachment). I want to add that Plan Name or id to a custom field in Easy Profile. I can't see any obvious way to do this. Is there any way to put some code in Easy Profile somewhere to do this(ie an SQL query against the Membership Pro tables)?
Thanks in advance for any help.
Attachments (1)
Accepted Answer
admin Accepted Answer
Admin
Hi,
sorry this is a bit complex. The easiest way is to set manually the plan name, You need to insert this PHP code for each subscription plan so it can be different for each plan
$user->field_alias= 'Premium';
// or
$user->field_alias= 'Basic';
admin Accepted Answer
Admin
Hi,
I does not know if there is a Membership Pro plugin that update Easy Profile's fields. Anyway I'm sure that after a sbscription is created then Membership Pro allow you to launch a SQL query, so you should be able to update Easy Profile's fields of a specific user.
  1. 3 weeks ago
  2. Support
  3. # 1
davidunwin Accepted Answer
Pro
We checked Membership Prof first and they do not have anywhere we could run an SQL to update EasyProfile Tables.....:(
  1. 3 weeks ago
  2. Support
  3. # 2
admin Accepted Answer
Admin
Hi,
then you can try to launch a PHP script to update EasyProfile informations.

DOCS:
Membership Pro PHP plugin: https://membershipprodoc.joomservices.com/plugins/script-plugin
Easy Profile UserObject: http://docs.easy-profile.com/index.php/article/jsnuser-object


require_once(JPATH_SITE.'/components/com_jsn/helpers/helper.php');
$user=JsnHelper::getUser($row->user_id); // I assume that the ID of the user is stored into a variable called "user_id" but I'm not sure
$user->field_alias= 'Plan Name'; // Replace "field_alias" with the alias of the Easy Profile's field where you need to store the plan name
$user->save();
  1. 3 weeks ago
  2. Support
  3. # 3
davidunwin Accepted Answer
Pro
Thank you for that.
I will try testing it
  1. 3 weeks ago
  2. Support
  3. # 4
davidunwin Accepted Answer
Pro
Ok I have looked at this solution and I can see how it would work. The user_id field is in the Membership Pro records, no problem. The Membership plan is there also but only the id field is stored in the subscriber table (see screen shot) . We would like to store the Membership Plan Title.

The Membership Plan Title is stored in another table (see second screen shot). We would like to store that in Easy Profile. That means doing a lookup of the membership plan table. I'm afraid that is beyond my very limited PHP coding skills. Is there any chance you could provide some sample coding to do the look up and store the Plan Title in the Easy Profile field?
Thanks in advance.
Attachments (2)
  1. 3 weeks ago
  2. Support
  3. # 5
davidunwin Accepted Answer
Pro
I can understand it being complex, so thank you for supplying a workaround....much appreciated
  1. 3 weeks ago
  2. Support
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy ProfileĀ® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.