PDA

View Full Version : Mass-move users from 2 different primary and secondary usergroups via SQL query


SaN-DeeP
10-28-2010, 09:12 AM
Hi, We have following usergroups.

UserGroup ID = 2 (Members)
UserGroup ID = 24 ((Subcribed or Paid Members)

All Registered Users = Members (2)
Paid Members = Members (Primary Group 2) + Additional Usergroup (24)

We have closed our Paid Content and set everything to free.
We need to mass-move all Subcribed Members from (Members (Primary Group 2) + Additional Usergroup (24)) to Paid Usergroup (Primary Usergroup 24) only

Please also give queries to undo/revert the changes (one of site is heavily modified and if things break, we will set users back to original way)

Unable to play with queries.

Thank You.