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

Reset message count to zero for all users?

Discussion in 'XenForo Questions and Support' started by Renada, Feb 25, 2011.

  1. Renada

    Renada Active Member

    Hi all,

    Is there a way I can reset all users message counts to zero? I've imported my user groups and users but that's all I want to keep - I'm starting in a new direction with the forum. Is there a query I can run to do this?

    Regards,
    Renada :)
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user SET message_count = 0

    Take a backup first though, just in case.
     
  3. Renada

    Renada Active Member

    Worked like a charm Brogan, thank you :)

    p.s. and thank you for the lightning speed reply :)
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    For reference, you can actually adjust message count, likes and trophy points in the ACP for each user.

    I presumed you wouldn't want to do each one individually though ;)
     
  5. Renada

    Renada Active Member

    Thanks for that Brogan. This time I wanted to wipe everything as I'm starting my users off from scratch but that's useful to know.

    What about Avatars? Can I batch upload a complete set for people to choose from? I didn't see that option anywhere.

    Regards,
    Renada :)
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    There is no option for an avatar gallery.
     
  7. Renada

    Renada Active Member

    Oh :(
     

Share This Page