1. 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

Discussion in 'XenForo Questions and Support' started by psx, Mar 27, 2016.

  1. psx

    psx Active Member

    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?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Trophies are only awarded once.

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

    wang Well-Known Member

    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.
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  5. psx

    psx Active Member

  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
    cgunes, psx and wang like this.

Share This Page