How to mass activate these using PhpMyAdmin

[zitu4life]

Hello there

I suspect some clients has Single sign-on un-tick. How to mass activated i for all clients using phpMyAdmin. What sql query to use?

Same question for this new future.

Edited May 8, 2020 by zitu4life

[brian!]

13 hours ago, zitu4life said:

I suspect some clients has Single sign-on un-tick. How to mass activated i for all clients using phpMyAdmin. What sql query to use?

UPDATE tblclients SET allow_sso = '1';

13 hours ago, zitu4life said:

Same question for this new future.

I think, though i'm not 100% sure, that they're all on by default when an account is created - and only if you want one or more of them to be disabled en masse, would you need to use a SQL query.

if you wanted ALL clients to have ALL email notifications enabled, you would just NULL the appropriate column...

UPDATE tblclients SET email_preferences = NULL;

... remembering of course that the client can login and disable/enable any of them from their client area at any time.