XF 2.2 How can I bulk delete the profile banner ?

[sameeraml]

My profile banner folder consumes around 3GB of size. I would like to delete all profile banners and allow only certain group of users to upload profile banner. In batch update users I can an option to remove avatar, but there is no such option available for profile banners. Any help will be appreciated

 

[KenB]

+1 on this I'd like to know how to mass delete the profile banners similarly

 

[nocte]

Such a functionality simply does not exist in XF 2.2 nor in XF 2.3.

So, you might post a suggestion:

XenForo suggestions

Please post any suggestion that you'd like to see as part of XenForo here. If you have a suggestion for an official add-on, please use the correct add-on suggestion forum. If you have a suggestion for a third-party add-on, please post it in the add-on's thread.

xenforo.com

Only way at the moment: a 3rd party or custom add-on.

 

[KenB]

Such a functionality simply does not exist in XF 2.2 nor in XF 2.3.

So, you might post a suggestion:

XenForo suggestions

Please post any suggestion that you'd like to see as part of XenForo here. If you have a suggestion for an official add-on, please use the correct add-on suggestion forum. If you have a suggestion for a third-party add-on, please post it in the add-on's thread.

xenforo.com

Only way at the moment: a 3rd party or custom add-on.

Do you know of such an add-on? I've a SQL query which has isolated the accounts but I can't see which field to reset to remove the banners

 

[James]

Do you know of such an add-on? I've a SQL query which has isolated the accounts but I can't see which field to reset to remove the banners

@AndyB has one. Note the 35 price tag is for all of his addons of which he has many.

Delete profile banners all

May 24, 2023

Deletes all profile banners.

• AndyB
• Add-ons [2.x]

 

[nocte]

Normally it is not a good idea to mess around with SQL queries, but as this task is quite simple, you might want to give it a try.

The code from the ProfileBannerService:

    public function deleteBanner()
    {
        $this->deleteBannerFiles();
        $profile = $this->user->Profile;
        $profile->bulkSet([
            'banner_date' => 0,
            'banner_optimized' => false,
            'banner_position_y' => null,
        ]);
        $profile->save();
        if ($this->logIp)
        {
            $ip = ($this->logIp === true ? $this->app->request()->getIp() : $this->logIp);
            $this->writeIpLog('delete', $ip);
        }
        return true;
    }

    // removed..

    protected function deleteBannerFiles()
    {
        if ($this->user->Profile->banner_date)
        {
            foreach ($this->sizeMap AS $code => $size)
            {
                File::deleteFromAbstractedPath($this->user->Profile->getAbstractedBannerPath($code));
            }
        }
    }

So, if you want to remove all profile banners at once:

Step 1:

UPDATE
    `xf_user_profile`
SET
    `banner_date` = 0,
    `banner_position_y` = NULL,
    `banner_optimized` = 0

Step 2:

Remove all profile banners from the web server (they should be in the folders data/profile_banners/l and data/profile_banners/m).

---

Notes:

• This will not update the user change log.
• Untested and on your own risk.
• Make a backup before you do this.

 

[KenB]

Normally it is not a good idea to mess around with SQL queries, but as this task is quite simple, you might want to give it a try.

The code from the ProfileBannerService:

    public function deleteBanner()
    {
        $this->deleteBannerFiles();
        $profile = $this->user->Profile;
        $profile->bulkSet([
            'banner_date' => 0,
            'banner_optimized' => false,
            'banner_position_y' => null,
        ]);
        $profile->save();
        if ($this->logIp)
        {
            $ip = ($this->logIp === true ? $this->app->request()->getIp() : $this->logIp);
            $this->writeIpLog('delete', $ip);
        }
        return true;
    }

    // removed..

    protected function deleteBannerFiles()
    {
        if ($this->user->Profile->banner_date)
        {
            foreach ($this->sizeMap AS $code => $size)
            {
                File::deleteFromAbstractedPath($this->user->Profile->getAbstractedBannerPath($code));
            }
        }
    }

So, if you want to remove all profile banners at once:

Step 1:

UPDATE
    `xf_user_profile`
SET
    `banner_date` = 0,
    `banner_position_y` = NULL,
    `banner_optimized` = 0

Step 2:

Remove all profile banners from the web server (they should be in the folders data/profile_banners/l and data/profile_banners/m).

---

Notes:

• This will not update the user change log.
• Untested and on your own risk.
• Make a backup before you do this.

Thank you very much for this, works a charm