cms_userprefs table: How to edit all users to use WYSIWYG

reviewum · Post by **reviewum** » Mon Feb 21, 2005 12:46 am

Hi All,

I've got a lot of newbie users who want to simply upload their pages and images. With the upgrade to the new version and removal of HTML Area I'm wondering how I can edit all the user's settings to be WYSIWYG and whichever editor I select (for example, TinyMCE).

I'm in the cms_userprefs table but can't make heads nor tails of what to set this to. For example, the admin user has four different entries like this:

1 use_wysiwyg 1 NULL
1 use_javasyntax 0 NULL
1 default_cms_language NULL
1 wysiwyg TinyMCE NULL

100rk · Post by **100rk** » Mon Feb 21, 2005 12:57 am

reviewum wrote:Hi All,

I've got a lot of newbie users who want to simply upload their pages and images. With the upgrade to the new version and removal of HTML Area I'm wondering how I can edit all the user's settings to be WYSIWYG and whichever editor I select (for example, TinyMCE).

I'm in the cms_userprefs table but can't make heads nor tails of what to set this to. For example, the admin user has four different entries like this:

1 use_wysiwyg 1 NULL
1 use_javasyntax 0 NULL
1 default_cms_language NULL
1 wysiwyg TinyMCE NULL

Just set default OTHER wysiwyg editor in user preferences for user 'admin' (you have to be logged in as admin)

and take a look into database again

Ted · Post by **Ted** » Mon Feb 21, 2005 12:59 am

The SQL statement for something like that would be:

Code: Select all

UPDATE cms_userprefs SET value = 'HTMLArea' where preference = 'wysiwyg';

However, there is (and will continue to be) a separately downloadable HTMLArea that you can install to have the same functionality.

reviewum · Post by **reviewum** » Mon Feb 21, 2005 1:33 am

Thanks for the help. Is there a way to "force" all users to use one WYSIWYG editor?

For example, most of my users were using HTMLArea, but now I want to move them, and all the text users over to TinyMCE. So, I need to:

1) Convert all users (ones with and without a WYSIWYG setting) to TinyMCE
2) Have the default (or only) option for editor to be TinyMCE.

Does that make sense?

Ted · Post by **Ted** » Mon Feb 21, 2005 10:35 am

There is no way to force a particular WYSIWYG. Never really thought it would be necessary...

100rk · Post by **100rk** » Mon Feb 21, 2005 11:21 am

reviewum wrote:Is there a way to "force" all users to use one WYSIWYG editor?

Yes - just install only one

Ted · Post by **Ted** » Mon Feb 21, 2005 1:16 pm

lol. Good point. Just set the other one as Inactive.

reviewum · Post by **reviewum** » Mon Feb 21, 2005 5:59 pm

Thanks for the replies.

It isn't as much of an issue as to which WYSIWYG editor, but to use a specific WYSIWYG editor over just the plain text editor.

CMS Made Simple Forums