No announcement yet.

Question about AFTER resetting users reputations

  • Filter
  • Time
  • Show
Clear All
new posts

  • Question about AFTER resetting users reputations

    Hello, I would like to reset everyone's REP to 10 the default (found the queries to do that). After resetting the counters is there a way to rebuild REP according to the vbulletin REP options. So after the reset they all start with 10, running another query will set all REP to current REP options (dates, post, etc).

    Sorry this is for vBulletin 3.8. Please move.

  • #2
    To do that, first backup your database. Then run these queries to reset the reputations (assuming no table prefixes):

    DELETE FROM reputation;

    UPDATE user SET reputation = 0;

    UPDATE user SET reputationlevelid = 10;

    Then you need to run this counter:

    Admin CP --> Import & Maintenance --> Update Counters --> Rebuild User Reputation
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


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