changing membership level from the database

Hi Una team,

As I mentioned in my previous post there is a problem about the default (additional new)  profile level. For a temporary solution I need to change the membership level of the some of the new profiles from the database with code. My questions are:

  1. In the  sys_acl_levels_members table IDlevel : profile level and IDmember : profile id , are these correct?
  2. Is it enough to change the IDlevel of the corresponding IDmember to the desired level for changing the membership level of a profile?
    (if these are not correct / enough how can we change the membership level of a profile from database?)
  3. Is this action triggers "your membership changed" email ?
  • 107
  • More
Replies (1)
    • 1. In `sys_acl_levels_members` table `IDlevel` is profile membership level id from `sys_acl_levels` table and `IDmember` is profile id from `sys_profiles` table.

      2. I think yes, but it's better to also clear `sys_acl_actions_track` table for profiles who's level was changed.

      3. Changing level via database will not send email to the user that their level was changed

      Login or Join to comment.