Remove all reputation left by a certain user?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • telc
    Senior Member
    • Oct 2001
    • 239
    • 3.5.x

    Remove all reputation left by a certain user?

    How can I remove all reputation left by a certain user. Does anyone have a safe query I can run that will do this without corrupting the reputation system.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    DELETE * FROM reputation WHERE whoadded = XXXX;
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • telc
      Senior Member
      • Oct 2001
      • 239
      • 3.5.x

      #3
      Thanks, will I have to update counter or anything after running it?

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73981

        #4
        There is no counter for reputation.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • telc
          Senior Member
          • Oct 2001
          • 239
          • 3.5.x

          #5
          Originally posted by Wayne Luke
          There is no counter for reputation.
          What is "Rebuild User Reputation" under Counters

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73981

            #6
            Actually have never noticed it. I guess if I have to rebuild counters, I just start at the top and go through the list. But I have rarely had a need to do anything in update counters.

            You could, any user would lose reputation (or gain depending). If you do promotions based on reputation it could change their usergroups.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

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