Page 1 of 1
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 12:46 am
by reviewum
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
Re: cms_userprefs table: How to edit all users to use WYSIWY
Posted: Mon Feb 21, 2005 12:57 am
by 100rk
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
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 12:59 am
by Ted
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.
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 1:33 am
by reviewum
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?
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 10:35 am
by Ted
There is no way to force a particular WYSIWYG. Never really thought it would be necessary...
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 11:21 am
by 100rk
reviewum wrote:Is there a way to "force" all users to use one WYSIWYG editor?
Yes - just install only one
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 1:16 pm
by Ted
lol. Good point. Just set the other one as Inactive.
cms_userprefs table: How to edit all users to use WYSIWYG
Posted: Mon Feb 21, 2005 5:59 pm
by reviewum
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.