[Forum] I need a query to change all users Message editor Interface

[katoona]

What query can I run to change Message Editor Interface from Simple to Enchanced Interface for all registered users.

I have imported 20.000 members from an old forum, and everyone has Simple editor as standard, and even if I tell users how to change it, only a few actually take the time to do it.

[katoona]

I figured it out on my own.

[Matthew Gordon]

I know you said you figured it out on your own, but I'll post the answer anyway in case someone else has the same issue.

In the Admin CP -> Maintenance -> Execute SQL Query, there's actually a list of "automatic queries" available (note that you have to give yourself access to this function in includes/config.php):


The exact query that it runs is as follows, in case you don't want to use this function:

UPDATE user SET showvbcode = 2