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

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X