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

XF 1.2 Trophies give by mistake to entire community, how to revert?

Discussion in 'XenForo Questions and Support' started by Alexey.P, Jul 28, 2013.

  1. Alexey.P

    Alexey.P Member

    Hello,

    I've made a 10,000 posts Trophy and by accident I made it:
    " User has posted no more than X messages: "

    And boom! every one got 100 Trophy points :/

    Is there a way to fix? I've edited to Trophy to:
    " User has posted at least X messages: "

    But every one still kept his extra 100 points...
     
  2. JulianD

    JulianD Well-Known Member

    You can try and delete the Trophy and see if it fixes by itself. I haven't seen the code so I don't know what is being done when you delete a trophy.

    If that doesn't work, you might need to go into the database and mess a little bit with the xf_user_trophy table. As always, backup your database before trying anything.
     
    Alexey.P likes this.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Trophies can't be revoked once awarded.

    You would need to manually edit the database, as stated above.
     
  4. Alexey.P

    Alexey.P Member

  5. Mike

    Mike XenForo Developer Staff Member

    Deleting it should remove it (and the points) from everyone - though depending on how many people were awarded it, as this could be a long running operation.
     
    Alexey.P likes this.
  6. Alexey.P

    Alexey.P Member

    Ow, gonna try this out.

    Edit: it worked, Mike is my new hero, yup.
     
  7. Alexey.P

    Alexey.P Member

    I still seem to get some issues.

    How can I simply restart it all?
    For example a Moderator have 12 points while he should have 20 just for being a Moderator..

    Is there any trick to fix all members trophies to sync?
     
  8. Jeremy

    Jeremy XenForo Moderator Staff Member

    What is the criteria for a moderator trophy? Does he satisfy it?
     
  9. Alexey.P

    Alexey.P Member

    Here is an easy example.
    I have 594 messages, 63 likes and only 22 trophy points (with XD default trophy model).
    I should have at least 40..
     
  10. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  11. Alexey.P

    Alexey.P Member

    Last edited: Aug 11, 2013
  12. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Everyone will have 0 trophy points after running those two queries. Then the cron will re-award the trophies that currently exist based on current criteria, with the addendum that the trophy cron only updates users who have been active in the last 24 hours, so there may be a delay for some users despite manually running the cron. Basically read my post in that thread.

    If you have more points than expected then you need to review your trophy criteria. If you unexpectedly have 0 points then you are probably inactive and as such have not yet been processed by the cron.
     
  13. Alexey.P

    Alexey.P Member

    I used both methods.

    Users logged in and out, still few of them with zero (o) points :(
     
  14. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Double check to make sure they meet all criteria for the expected trophies.
     
  15. Alexey.P

    Alexey.P Member

    Yes I did,
    They even got the basic ones from the default version. like 1point for the first message..
     
  16. Alexey.P

    Alexey.P Member

    I even updated to 1.2.1 because of that:
    And I went to admin.php?cron/, clicked run on " Update User Trophies Next Run: ‏23/8/13 at 02:40 " and nothing happen ..
    Still members with zero points never been recovered
     
  17. Jeremy

    Jeremy XenForo Moderator Staff Member

    The new tool isn't the cron. It's under the rebuild caches section. Run it under there.
     
  18. Alexey.P

    Alexey.P Member

    Rebuild User Caches?
    I did rebuilt-now, and nothing changed either..
     
  19. Mike

    Mike XenForo Developer Staff Member

    No. "Rebuild Trophies".
     
    Alexey.P likes this.
  20. Alexey.P

    Alexey.P Member

    Damn it, finally!!!!!! Thank you so much @Mike
     

Share This Page