XF 2.2 update trophies

[interforo]

User no longer meets trophy criteria, how to remove that trophy?
I am looking for a way to update trophies on my board.
No the cron run does not fix it

 

[Paul B]

Once a trophy has been awarded, it is not removed if the member no longer meets the criteria.

 

[interforo]

Once a trophy has been awarded, it is not removed if the member no longer meets the criteria.

but that's a bug!

 

[Paul B]

It's not a bug.

The member met the criteria and was awarded a trophy specifically set for that criteria.

 

[interforo]

It's not a bug.

The member met the criteria and was awarded a trophy specifically set for that criteria.

OK but think about this scenario:
I had awarded users that reach 10.000 posts ok?

Now after a mass clean of my forum, the user that has now 3.000 posts shows a trophy for 10.000 posts.
That's not a good representation of my forum as of now

 

[Paul B]

Delete the trophy and create a new one.

 

[interforo]

Delete the trophy and create a new one.

is there a query that simply updates the trophies?