Friend request notification: Turn on for all users?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TNCclubman
    Member
    • Sep 2008
    • 59
    • 3.7.x

    Friend request notification: Turn on for all users?

    How can I turn it on for all my members at once?

    Either through the ADMINCP or a mysql command in phpmyadmin...

    I imported 39,000 members from phpbb and they're all turned off.

    Thanks!
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    Run this query:

    UPDATE user
    SET options = options + 2097152
    WHERE NOT(options & 2097152)

    Comment

    • TNCclubman
      Member
      • Sep 2008
      • 59
      • 3.7.x

      #3
      thanks jake!

      Comment

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