Jump to content

How to mass activate these using PhpMyAdmin

Recommended Posts

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated