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

Rebuild trophy points

Discussion in 'XenForo Questions and Support' started by ChemicalKicks, Oct 15, 2011.

  1. ChemicalKicks

    ChemicalKicks Well-Known Member

    I understand I can't do this through the acp. Is there anyway I can do it through a query maybe.

    I've gone through editing existing trophies and I'm feeling a bit bad that those who have already been awarded the points won't get the benefit of the increased points per award.
  2. Mike

    Mike XenForo Developer Staff Member

    Have you confirmed that people don't have updated point values? There is code that updates the amount of points for people if you change the trophy values.
    ChemicalKicks and Brogan like this.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Good to know Mike, thanks.

    Presumably that also works if you reduce the points for a particular trophy?

    Like the OP, I'm also reviewing trophies now that there are more criteria.
  4. ChemicalKicks

    ChemicalKicks Well-Known Member

    Ah well tbh I hadn't checked, I had read somewhere else here that the awards are static.

    Is that feature in 1.0.4 or new to 1.1
  5. Mike

    Mike XenForo Developer Staff Member

    Yeah, up or down.

    Since day one. :)
    Brogan likes this.
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Thanks Mike, I just learned something new :)
  7. Crazy-Achmet

    Crazy-Achmet Active Member

    I have to push this. I've just moved to XenForo and some trophie points got messed up.

    Is there any way to rebuild the whole trophie points calculation for all users?
  8. Crazy-Achmet

    Crazy-Achmet Active Member

    /edit: I've seen the table 'xf_user_trophy' seems to be right, but value of 'xf_user.trophy_points' is totally misscalculated.
  9. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member


    edit - or you can just run the second of the two queries to recalculate point values based on trophies that have already been awarded, rather than running both queries which will zero out existing trophies and re-award them. It depends on the situation.
    Crazy-Achmet likes this.
  10. Crazy-Achmet

    Crazy-Achmet Active Member

    Thanks alot Jake!!!

Share This Page