- Forums
- Archive
- CBSubs - Paid Membership Management Solution
- News Discussions
- [SOLVED] CBSubs to change username first time user subscrib
[SOLVED] CBSubs to change username first time user subscrib
- Ducatiklubben
- OFFLINE
-
Senior Member
- Posts: 44
- Thanks: 0
- Karma: 0
13 years 6 months ago #143996
by Ducatiklubben
[SOLVED] CBSubs to change username first time user subscrib was created by Ducatiklubben
Hello,
On our site we are using numbers as username for all active users. We have done this manually after the user is manually enabled in the back-end.
We have just installed CBSubs and planning to use it to control so that only paying users have access to forum etc.
My problem is that Joomla by default is setting username to "name + last-name". Now when we are automating the step to add the user to joomla we need some intelligence to set the usernamne to a number after the user has payed the subscription.
I have been reading this thread, which seems to have the same problem:
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,95084/catid,90/limit,6/limitstart,12/
Anyone have ideas how to solve this? I need some help here
thanks
Post edited by: krileon, at: 2010/11/26 15:14
On our site we are using numbers as username for all active users. We have done this manually after the user is manually enabled in the back-end.
We have just installed CBSubs and planning to use it to control so that only paying users have access to forum etc.
My problem is that Joomla by default is setting username to "name + last-name". Now when we are automating the step to add the user to joomla we need some intelligence to set the usernamne to a number after the user has payed the subscription.
I have been reading this thread, which seems to have the same problem:
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,95084/catid,90/limit,6/limitstart,12/
Anyone have ideas how to solve this? I need some help here
thanks
Post edited by: krileon, at: 2010/11/26 15:14
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68492
- Thanks: 9080
- Karma: 1434
13 years 6 months ago #144038
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:CBSubs to change username first time user subscrib
Yes this can be done using CBSubs SQL Actions, you'll need a complex query to check against the usernames and generate a sequential one or a random one that isn't already used. Example as follows.
INCREMENTAL
[code:1]
UPDATE `#__users` SET `username` = ( ( SELECT `username` FROM `#__users` WHERE `username` >= 1 ORDER BY `username` DESC LIMIT 1 ) + 1 ) WHERE `id` = [user_id]
[/code:1]
RANDOM
[code:1]
UPDATE `#__users` SET `username` = SUBSTRING( RAND(), 3, 6 ) WHERE `id` = [user_id]
[/code:1]
INCREMENTAL
[code:1]
UPDATE `#__users` SET `username` = ( ( SELECT `username` FROM `#__users` WHERE `username` >= 1 ORDER BY `username` DESC LIMIT 1 ) + 1 ) WHERE `id` = [user_id]
[/code:1]
RANDOM
[code:1]
UPDATE `#__users` SET `username` = SUBSTRING( RAND(), 3, 6 ) WHERE `id` = [user_id]
[/code:1]
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- Ducatiklubben
- OFFLINE
-
Senior Member
- Posts: 44
- Thanks: 0
- Karma: 0
13 years 6 months ago #144154
by Ducatiklubben
Replied by Ducatiklubben on topic Re:CBSubs to change username first time user subscrib
Hello Krileon,
Thanks for the code.
I have installed and tried it out and it seems to be executing ok. I don't get any error message when a user gets activatet, BUT nothing happens to the username.
The username for the new user is still "name + lastname"
Can I enable some error logging to be able to see what is happening?
Post edited by: Ducatiklubben, at: 2010/10/15 22:16
Thanks for the code.
I have installed and tried it out and it seems to be executing ok. I don't get any error message when a user gets activatet, BUT nothing happens to the username.
The username for the new user is still "name + lastname"
Can I enable some error logging to be able to see what is happening?
Post edited by: Ducatiklubben, at: 2010/10/15 22:16
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68492
- Thanks: 9080
- Karma: 1434
13 years 6 months ago #144233
by krileon
Is the user subscribing to the plan you've added the query to? Have you ensured the CBSubs SQL Actions plugin is public and published?
You may want to review documentation subscriber incubator project CB Queries which can execute (internal and external) database queries at various locations via CB triggers such as After Registration. This would cause the query to apply to ALL users after the register (if that's what you want). More on incubator can be found here .
It's possible the query is happening and CB is storing AFTER the query causing the first + last to override the new username.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:CBSubs to change username first time user subscrib
Not that I am aware.Can I enable some error logging to be able to see what is happening?
Is the user subscribing to the plan you've added the query to? Have you ensured the CBSubs SQL Actions plugin is public and published?
You may want to review documentation subscriber incubator project CB Queries which can execute (internal and external) database queries at various locations via CB triggers such as After Registration. This would cause the query to apply to ALL users after the register (if that's what you want). More on incubator can be found here .
It's possible the query is happening and CB is storing AFTER the query causing the first + last to override the new username.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- Ducatiklubben
- OFFLINE
-
Senior Member
- Posts: 44
- Thanks: 0
- Karma: 0
13 years 6 months ago #144379
by Ducatiklubben
Replied by Ducatiklubben on topic Re:CBSubs to change username first time user subscrib
krileon wrote:
Yes, and the plugin is both public and published.
Have I understand it correctly if I can configure so that I can use triggers to execute the SQL after the first registration has happened?
What I'm trying to accomplish is that when the user registers the first time and have done the payment, the user name changes to the number. This number shall never be changed in the future, even if the subscription expires. we never deletes a user or re-use the member number, just blocks the user to enter the site.
Is the user subscribing to the plan you've added the query to? Have you ensured the CBSubs SQL Actions plugin is public and published?
Yes, and the plugin is both public and published.
You may want to review documentation subscriber incubator project CB Queries which can execute (internal and external) database queries at various locations via CB triggers such as After Registration. This would cause the query to apply to ALL users after the register (if that's what you want). More on incubator can be found here .
Have I understand it correctly if I can configure so that I can use triggers to execute the SQL after the first registration has happened?
What I'm trying to accomplish is that when the user registers the first time and have done the payment, the user name changes to the number. This number shall never be changed in the future, even if the subscription expires. we never deletes a user or re-use the member number, just blocks the user to enter the site.
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68492
- Thanks: 9080
- Karma: 1434
13 years 5 months ago #144421
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:CBSubs to change username first time user subscrib
There's only 1 registration, but yes you can configure it to execute a query/queries after registration.Have I understand it correctly if I can configure so that I can use triggers to execute the SQL after the first registration has happened?
Then using CBSubs SQL Actions isn't the best approach as everytime they resubscribe/renew it will re-execute that query.What I'm trying to accomplish is that when the user registers the first time and have done the payment, the user name changes to the number. This number shall never be changed in the future, even if the subscription expires. we never deletes a user or re-use the member number, just blocks the user to enter the site.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Archive
- CBSubs - Paid Membership Management Solution
- News Discussions
- [SOLVED] CBSubs to change username first time user subscrib
Time to create page: 0.238 seconds
-
You are here:
- Home
- Forums
- Archive
- CBSubs - Paid Membership Management Solution
- News Discussions
- [SOLVED] CBSubs to change username first time user subscrib