Prune Avatars and Signatures of Banned Users

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pocket Aces
    Member
    • Mar 2007
    • 99
    • 4.2.x

    Prune Avatars and Signatures of Banned Users

    How to remove all uploaded avatar and signature images of members of a certain usergroup like a Banned group?
    Database queries are fine but if there's a safer or cleaner way to do it that would be better.
    vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73979

    #2
    I don't know what the queries would be offhand but you can delete their signature and avatars by editing the user in the AdminCP. This will also delete any uploaded images from disk, something a query can't do.
    Translations provided by Google.

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

    Comment

    • Pocket Aces
      Member
      • Mar 2007
      • 99
      • 4.2.x

      #3
      Thank you for your response Wayne.

      But I thought mentioning the words 'prune', 'all', and 'usergroup' in my post should be clear enough that I'm looking for a 'bulk' solution.
      In 12 years and out of 1.5 million users, we have 9000 users in banned group, and over 200 000 users in inactive group.
      We are hoping to free some disk space by removing the uploaded profile images on those 209 000 users.
      Last edited by Pocket Aces; Tue 9 Oct '18, 4:38pm.
      vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17

      Comment

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

        #4
        I don't have a bulk solution. Pruning the users should delete their uploaded images.
        Translations provided by Google.

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

        Comment

        • Pocket Aces
          Member
          • Mar 2007
          • 99
          • 4.2.x

          #5
          well thats too bad, what a waste of server resources
          vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17

          Comment

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

            #6
            I've created a feature request to have this added to vBulletin 5 - https://tracker.vbulletin.com/vbulle...sues/VBV-18869
            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...