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.
Get Involved
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 » Thu Dec 24, 2009 10:37 pm

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 » Thu Dec 24, 2009 11:39 pm

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 » Fri Dec 25, 2009 1:26 am

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 » Fri Dec 25, 2009 8:04 am

I want to use them just delete all old because requirements has changed etc...

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50582
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 » Fri Dec 25, 2009 4:17 pm

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 » Fri Oct 30, 2015 6:09 pm

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: 13917
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: How to delete all sig and avatars

Post by 3Di » Fri Oct 30, 2015 6:10 pm

ofcourse :)

try asking into the 3.1 support forum ;)
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
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50582
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 » Sat Oct 31, 2015 12:58 pm

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: 50582
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 » Sat Oct 31, 2015 1:07 pm

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 » Wed Mar 02, 2016 5:02 pm

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
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: How to delete all sig and avatars

Post by RMcGirr83 » Wed Mar 02, 2016 5:06 pm

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; 
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

Locked

Return to “[3.0.x] Support Forum”