Announcement

Collapse
No announcement yet.

Cut all user reputations in half?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cut all user reputations in half?

    How would I cut all user reputations in half? (or in a third/fourth, etc).

    I'm assuming it would require some sql query. I could probably do it, but I don't know what to do with the reputationlevelid. What is that for?

    Thanks -vissa

  • #2
    Run this query (backup first):

    Code:
    UPDATE reputation
    SET reputation = reputation / 2
    You can divide by 3 or 4 if you want. Then update your reputation counters:

    Admin CP -> Maintenance -> Update Counters -> Rebuild User Reputation

    This will update the reputation counts and reputationlevelids.

    Comment


    • #3
      Thank You!

      Now if I rebuild user reputation, that will eliminate any manual adjustments my mods have made, correct? Also, am I correct in assuming that reps given on deleted (permanently) threads will not be counted if it is rebuilt?

      Thanks
      -Vissa

      Originally posted by Jake Bunce
      Run this query (backup first):

      Code:
      UPDATE reputation
      SET reputation = reputation / 2
      You can divide by 3 or 4 if you want. Then update your reputation counters:

      Admin CP -> Maintenance -> Update Counters -> Rebuild User Reputation

      This will update the reputation counts and reputationlevelids.

      Comment


      • #4
        Rebuilding the counter will rebuild rep numbers based on the records in the reputation table which are updated by that query.

        When a thread is physically deleted, its rep is also deleted. So rebuilding the counter would not consider rep for deleted threads.

        Comment

        Loading...
        Working...
        X