Rebuild trophy points

[ChemicalKicks]

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.

 

[Mike]

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.

 

[Paul B]

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.

 

[ChemicalKicks]

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.

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

 

[Mike]

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

Yeah, up or down.

Is that feature in 1.0.4 or new to 1.1

Since day one.

 

[Paul B]

Thanks Mike, I just learned something new

 

[FloV]

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?

 

[FloV]

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

 

[Jake Bunce]

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?

http://xenforo.com/community/threads/recalculate-trophy-points.30800/#post-351948

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.

 

[FloV]

Thanks alot Jake!!!