Membership ID sync with Joomla ID

  • Ahmad Arshad
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 3 months ago #151923 by Ahmad Arshad
Membership ID sync with Joomla ID was created by Ahmad Arshad
Dear Tuan,

Is it possible that the membership ID that are generated by MP can be synced with the natural JOOMLA ID that get assigned to anyone who signs up on the website?

Many thanks

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
3 years 3 months ago #151929 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership ID sync with Joomla ID
Hi Ahmad

You want Membership ID become Joomla username for that user? If so, it is not supported, but if it is really needed, I believe you can write a plugin to make that behavior. Just get Membership ID of the user, and update users database in Joomla with that Membership ID for the user.

Should not be a hard work, but Yes, you need programming skill to do the development

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Ahmad Arshad
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 3 months ago #151980 by Ahmad Arshad
Replied by Ahmad Arshad on topic Membership ID sync with Joomla ID
I was thinking more of the Joomla UserID that gets assigned when a person registers on the website e.g 1234 becomes the Membership ID of the subscriber....

I believe this is the function that needs to be overridden in tools.php in the controller..
Code:
public function generate_membership_id() 

so in the upate sql 
Code:
[b]$start[/b] 
becomes 
Code:
[b]$row->user_id[/b]

any thoughts on how it could be done without too much complications :) 

Please Log in or Create an account to join the conversation.

  • Ahmad Arshad
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 3 months ago #151981 by Ahmad Arshad
Replied by Ahmad Arshad on topic Membership ID sync with Joomla ID
Right now I am just running a SQL command that does this

update osmembership_subscribers set osmembership_subscribers.membership_id = osmembership_subscribers.user_id;

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
3 years 3 months ago #151989 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership ID sync with Joomla ID
If Membership ID is the same with User ID, then I'm unsure why you need Membership ID ? You can use User ID instead

Please Log in or Create an account to join the conversation.

  • Ahmad Arshad
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 3 months ago #151999 by Ahmad Arshad
Replied by Ahmad Arshad on topic Membership ID sync with Joomla ID
You are right. It seems to be working. I guess I was trying to get all data from one table osm_subscribers and it had membership_id and not user_id

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
3 years 3 months ago #152014 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership ID sync with Joomla ID
OK. So you have this requirement sorted ? Or you still have questions?

Tuan

Please Log in or Create an account to join the conversation.

  • Ahmad Arshad
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 3 months ago #152023 by Ahmad Arshad
Replied by Ahmad Arshad on topic Membership ID sync with Joomla ID
No i think I am good for now. Thank you for the explanation

Please Log in or Create an account to join the conversation.