How to let user ask for membergroup update?
How Do I?
Hello. Im working with a project that will have a possibility to ask/order for membergroup update. Simply from “members” to “pro” or similar, and from “Pros” back to “members”.
I remember addon called Charge can handle this but at this point we do not need for paid switch, rather just some sort of activity related and in its simplest, via basic form(when super admin has to manually do the work).
Is there addon or a way to power up the update from group A to B when you hit certain level of activity based on forum posts or (solspace) ratings or something similar activity?
We do not allow members to post their own channel entries but if there is a way to handle that membergroup update with those, I could make channel for “comments” to be a tricker element.
Hope you got the point im after, and hopefully someone could give me ideas, links to some addons and such?
Im still on EE2.10.1 because of reasons 😊
Thanks in advance
There is no built-in way to do just that that I am aware of (with the possible exception of the forums, which do have such an automatic ranking system, although it’s not based on membergroups.)
You could certainly do something like this with an SQL query (run query to see if conditions are met, then move matching members to second group), but you’ll need a way to trigger that query. You could stick it in a frequently hit template, but that might be computationally exepensive. There used to be a number of Cron plugins for EE which might be up to the job, but I am not fully up to date there. Another way might be a small shell script together with a real cron job, if your host allows for it.
Query could be just it and use login return as a tricker. By that way I could also add a “wohoo” alert if membergroup has been updated when user login to site. Sounds good but I dont know the magic how-to move member from A to B.
You mind give an dummy example of that part? Thanks
The moving part as such is not too difficult. You only need to change the group_id in exp_members, like so:
UPDATE `exp_members` SET group_id = '6' WHERE username = 'foobar'Many variations are, of course, possible. You’ll also need to determine the usernames or member_ids of the users to promote, too.
Thanks. I need to get some time to think this over and run some tests, but sounds there is a good chance to make things rocking.