1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 After Import - Clean-up

Discussion in 'XenForo Questions and Support' started by PrettyPixels, Sep 6, 2014.

  1. PrettyPixels

    PrettyPixels Active Member

    I just did an import to xenForo and need to universally set a couple of options for users. Can someone please tell me if there's a way to do the following (either through the admin panel or by running a MySQL query):

    - Hide the birth year/age of all existing members

    - Set the default subscription notification (for all existing members) to email

    - Set all existing topic subscriptions to email

    I appreciate any info or assistance you can offer.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user_option SET show_dob_year = 0;
    UPDATE xf_user_option SET default_watch_state = 'watch_email'
    The last one can't be done with a simple query.
    maszd likes this.
  3. PrettyPixels

    PrettyPixels Active Member

    Thanks, Brogan! :)

Share This Page