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

XF 1.5 Trophy Points Issue

psx

Active member
#1
Hi

I have reset a member Trophy Points to 0 in the admin panel, but now it doesn't move up or count.

How can I make it count again?
 

Brogan

XenForo moderator
Staff member
#2
Trophies are only awarded once.

Resetting the value in the ACP won't allow them to be awarded and counted again.
 

wang

Well-known member
#3
Reseting the trophy count from the admin panel, should not pose a problem for receiving trophy points in the future. Maybe that user is not getting any trophy points and that is why it is not doing anything.

It might be worth to run Update User Trophies cron. If that user has received trophies, rebuilding the trophy cache can solve the issue.
 

Jake Bunce

XenForo moderator
Staff member
#6
Is there a way to do it just for a specific user?
This should do it:

Code:
DELETE
FROM xf_user_trophy
WHERE user_id = 123;

UPDATE xf_user AS u
SET u.trophy_points = (
	SELECT SUM(t.trophy_points)
	FROM xf_user_trophy AS ut
	LEFT JOIN xf_trophy AS t ON (t.trophy_id = ut.trophy_id)
	WHERE ut.user_id = u.user_id
)
WHERE u.user_id = 123;
Replace 123 with the user id number.

The rest of the instructions are the same as that link I posted.