XF 1.5 Reset Trophy Points

[triforceguy1]

Hello,

I want to reset everyone's Trophy Points to zero for now, then have them recalculate once I reenable trophies, I am basically doing a massive overhaul on them. Is there a way to do this at all?

Thanks in advance
Leon

 

[wang]

Hello,

I want to reset everyone's Trophy Points to zero for now, then have them recalculate once I reenable trophies, I am basically doing a massive overhaul on them. Is there a way to do this at all?

Thanks in advance
Leon

This sql qury will do that:

UPDATE xf_user SET trophy_points = 0;

 

[triforceguy1]

This sql qury will do that:

UPDATE xf_user SET trophy_points = 0;

That worked fantastically!
Thank you very much

 

[wang]

That worked fantastically!
Thank you very much

You are very welcome

 

[Umar Asari]

How can I reset trophies. Look this:

I want to reset this setting. Without losing trophies of members.

 

[Jim Fox]

This sql qury will do that:

UPDATE xf_user SET trophy_points = 0;

That code looks super simple which is great.

I have yet to run anything in sql on my Xenforo 1.5 install, so how do I run this sql command?

I appreciate any help anyone has to offer with this.

Jim