I need help with two queries please Query 1: I am looking to change the primary user group to 24 which I will then purge via the admincp. Its the last part I'm having problems with. UPDATE xf_user SET user_group_id = 24 WHERE user ID = The Value in User_ID (column) AND Column_X = 2 (column) in Email_Check_2014 (table) Query 2: I am looking to mark these users so they don't get emails and need to reconfirm their email before posting. I have a second user group created but it looks like they added a field for this in 1.3? UPDATE xf_user SET user_state = "email_confirm_edit" WHERE user ID = The Value in User_ID (column) AND Column_X = 1 (column) in Email_Check_2014 (table) thanks!!