Script to convert members from standard to Gold

I'd like to convert all of my Standard members to Gold members. is there a script that I can run for this so I don't have to do each one individually?

I would run a query in your database tool; such as phpMyAdmin, and set all the membership levels to the desire one.

  That's a great idea. I only have a few that will not be Gold and I can easily change those. What is the query that I need to run?

Here are a few files that i made that will help set all memberships to one level and reset the admin account to level 3 .  

See attached files.

1. Upload membership_levels.php to your site.

2. Run yoursite.com/membership_levels.php first to get a listing of membership level ID's

3. Open membership_upgrade.php

    -Change the number '1' to the ID you got from membership_levels.php

    -Change NickName 'DolphinTechs' to the admin user name of your site

    -Save the file.

    -Upload membership_upgrade.php to your site.

4. Run yoursite.com/membership_upgrade.php

5. Remove these 2 files from your site for security reasons. IMPORTANT !

No, it is not the role he wants to set, it is the membership type, he wants to set his members to the same membership, gold.

Membership type is controlled by the role number in the profile table

The table, if I am not mistaken, is sys_acl_levels_members`

UPDATE `sys_acl_levels_members` SET `IDLevel` = '3' ;

Replacing 3 with the particular membership number.

Dolphin_jay, please check and correct my query.

edit: sys_acl_levels lists the memberships.  On my site gold number is 9

Are you sure?  I thought role 1 is regular member, role 3 is admin.  that it control the role of the user, not the membership level.

I have not actually tested this to see if it works. But i do know that is not how dolphin switches membership levels. Dolphin adds a entry to the sys_acl_levels_members table. The role remains as 1. Your method may work, but i don't believe it is the proper way.

I suspect this is to properly support expiring memberships and such.

Also, it sets a time for the membership to expire; which I did not account for.  If that is needed, you need to figure out the unix timestamp for the start and ending of the membership level and add that to the query.

Note: search on the net for "create unix timestamp" and you will find tools to do this for you.

you might be right...   i was going to fast...   doing to many things at once i suppose.

New zip file attached for sys_acl_levels_members

Sorry about the confusion in the first file set.  Wish i could just edit that post.... 

 Thanks.  If I can't get my web guys to fix it as part of the database merge, I'll try this.