Announcement

Collapse
No announcement yet.

I need a query to change all users Message editor Interface

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

  • #2
    I figured it out on my own.

    Comment


    • #3
      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):
      Click image for larger version

Name:	automaticquery.jpg
Views:	1
Size:	29.8 KB
ID:	3687172

      The exact query that it runs is as follows, in case you don't want to use this function:
      Code:
      UPDATE user SET showvbcode = 2

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X