How to delete all sig and avatars

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Durbatuluk
Registered User
Posts: 106
Joined: Thu Dec 29, 2005 8:22 pm

How to delete all sig and avatars

Post by Durbatuluk »

Hi is there some querry for database for deleting all user signatures and avatars? Thank you for it.
Durbatuluk
Registered User
Posts: 106
Joined: Thu Dec 29, 2005 8:22 pm

Re: How to delete all sig and avatars

Post by Durbatuluk »

Nobody knows this?
User avatar
sunsop
Registered User
Posts: 671
Joined: Sat Sep 05, 2009 6:36 am

Re: How to delete all sig and avatars

Post by sunsop »

Just DISABLE using avatars or signatures in the ACP.
Durbatuluk
Registered User
Posts: 106
Joined: Thu Dec 29, 2005 8:22 pm

Re: How to delete all sig and avatars

Post by Durbatuluk »

I want to use them just delete all old because requirements has changed etc...
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51669
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to delete all sig and avatars

Post by stevemaury »

Code: Select all

UPDATE phpbb_users SET `user_sig` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_sig_bbcode_uid` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_sig_bbcode_bitfield` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar_type` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar_width` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar_height` = '' WHERE `user_type` <> 2;
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: How to delete all sig and avatars

Post by Neuropass »

stevemaury wrote:

Code: Select all

UPDATE phpbb_users SET `user_sig` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_sig_bbcode_uid` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_sig_bbcode_bitfield` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar_type` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar_width` = '' WHERE `user_type` <> 2;
UPDATE phpbb_users SET `user_avatar_height` = '' WHERE `user_type` <> 2;
how can I do this on phpBB 3.1? the current code has syntax error.
User avatar
3Di
Former Team Member
Posts: 16052
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 - Frankfurt 🇩🇪
Name: Marco
Contact:

Re: How to delete all sig and avatars

Post by 3Di »

ofcourse :)

try asking into the 3.1 support forum ;)
To request support for our extensions you can also contact me here: phpBB Studio

Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
🚀 Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51669
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to delete all sig and avatars

Post by stevemaury »

What is the syntax error and what database are you using?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51669
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to delete all sig and avatars

Post by stevemaury »

Try this. Should work.

Code: Select all

UPDATE phpbb_users SET user_sig = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_sig_bbcode_uid = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_sig_bbcode_bitfield = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_type = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_width = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_height = '' WHERE user_type <> 2
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: How to delete all sig and avatars

Post by Neuropass »

stevemaury wrote:Try this. Should work.

Code: Select all

UPDATE phpbb_users SET user_sig = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_sig_bbcode_uid = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_sig_bbcode_bitfield = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_type = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_width = '' WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_height = '' WHERE user_type <> 2

Hi Steve,

I get this error on phpBB 3.1.8

https://gyazo.com/4602a046c8179725c40a64013fbb3c08

how can I fix it?
User avatar
RMcGirr83
Former Team Member
Posts: 21672
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: How to delete all sig and avatars

Post by RMcGirr83 »

The error should have told you everything you needed to know

Code: Select all

UPDATE phpbb_users SET user_avatar_width = 0 WHERE user_type <> 2;
UPDATE phpbb_users SET user_avatar_height = 0 WHERE user_type <> 2; 
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
Locked

Return to “[3.0.x] Support Forum”