najaru Posted February 3, 2013 Report Share Posted February 3, 2013 hello Michael how to delete all signature of certain x y z groups? query sql welcome :) thanks Quote Link to comment Share on other sites More sharing options...
Management Michael Posted February 4, 2013 Management Report Share Posted February 4, 2013 Try this, 3,4 being the member group ids. You may need to remove cached signatures in acp > system tab > cache management. UPDATE profile_portal pp JOIN members m ON (pp.pp_member_id=m.member_id) SET pp.signature='' WHERE member_group_id IN (3,4) If possible, might want to try on test board first, haven't tested this much. Quote Link to comment Share on other sites More sharing options...
najaru Posted February 5, 2013 Author Report Share Posted February 5, 2013 thanks michael. i will test on a local board . in ipb 3.3 i use the same code? Quote Link to comment Share on other sites More sharing options...
Management Michael Posted February 7, 2013 Management Report Share Posted February 7, 2013 in ipb 3.3 i use the same code? Yes, I don't see any database changes between now and then. Quote Link to comment Share on other sites More sharing options...
najaru Posted February 7, 2013 Author Report Share Posted February 7, 2013 ok thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.