Announcement

Collapse
No announcement yet.

Prune Avatars and Signatures of Banned Users

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

  • 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

  • #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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • #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 9th Oct '18, 4:38pm.
      vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17

      Comment


      • #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 customization and demonstration site.
        vBulletin 5 Documentation - Updated every Friday. Report issues here.
        vBulletin 5 API - Full / Mobile
        I am not currently available for vB Messenger Chats.

        Comment


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

          Comment


          • #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 customization and demonstration site.
            vBulletin 5 Documentation - Updated every Friday. Report issues here.
            vBulletin 5 API - Full / Mobile
            I am not currently available for vB Messenger Chats.

            Comment

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