OK, here's the dillemma - I need to figure out how to set up a cron job which does the following:
1 - search each user in Profiles table and see if field (new_field) is empty or not
2 - if not empty, then check and see if the value in 'new_field' matches any values in field (special_id) in new table (special_id_table)
a - if the value does exist in field 'special_id' from table 'special_id_table' then check user membership level
a.1 - if the user membership level is not equal to Membership B then change membership to Membership B
a.2 - if the user membership level is equal to Membership B then do nothing for this user, and cycle through to the next user and start over
b - if the value does not exist in field (special_id) from table (special_id_table) then check membership level
a - if membership level is equal to Membership B then change membership level to Standard Member
b - if membership level is not equal to Membership B then do nothing for this user and cycle through to the next user and start over
I hope this is understandabel - any questions, please leave me a message.
Thanks in advance