Set Gold Membership for all Member at once!

Is there a way to give all members a Gold Membership at once!

I have reinstalled one of my old site which has over 1400 members and I want to give them all a Gold Membership.

Can this be done?

It was a bit tricky but I made it :-)

Since those member with Standard membership are not inside "sys_acl_levels_members" at phpMyAdmin you will have to create them. I did it with Excel and imported it to the table.

Since all values are set to 0 except the memberID if you import that excel, I did export them as sql and edit the 0 Value sections with notepad++. They have now all the same date but who cares they got a better membership.

To make sure the members also have the membership you will have to add them at your "Profiles" table as well. Which is a bit more easy.

Just run the folowing command at your phpMyAdmin SQL:

UPDATE Profiles SET membership_id = 'new_membership_ID' WHERE membership_id = 'old_membership_ID';

Thats it, my members are happy and me too cos I learned something

Enjoy :-)

There was a faster way to copy all the members to that table.

First make sure sys_acl_levels_members is empty. Then run this SQL Query to copy all the members to it.

INSERT INTO `sys_acl_levels_members` (`IDMember`,`IDLevel`,`DateStarts`) SELECT `ID`,membership_ID,NOW() FROM `Profiles`;

I also can't find this membership_id field in the profiles table on either of my dolphin sites. One running 7.0.1 the other 7.0.2

Normally all that is needed to for the member to exist in the sys_acl_levels_members table.

Hi deano you are right, there is no membership_id in the orginal dol sql

I might have cos of the dolphin subscription mod.

Sorry :-) and thanks to make it a bit more easy :-)