Bidybag
08-23-2005, 03:10 AM
I am using Invision 2.0.3 and i need help with a query which will move all the members from the members table to the validating table in the database. Reason i want to do it is so i can resend the activation email to all members so they have to reactivate their account.
I tried using this query:
UPDATE ibf_members SET mgroup = 1 WHERE mgroup = 3
This only moves their group and changes their permissions, it doesnt actaully put them into the validating table.
The validating group uses different fields than the members group so i dont know how to insert all my members into it. Please can somebody help me
I tried using this query:
UPDATE ibf_members SET mgroup = 1 WHERE mgroup = 3
This only moves their group and changes their permissions, it doesnt actaully put them into the validating table.
The validating group uses different fields than the members group so i dont know how to insert all my members into it. Please can somebody help me