How to delete all sig and avatars

Durbatuluk · 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 · Post by **Durbatuluk** » Thu Dec 24, 2009 11:39 pm

Nobody knows this?

sunsop · Post by **sunsop** » Fri Dec 25, 2009 1:26 am

Just DISABLE using avatars or signatures in the ACP.

Durbatuluk · Post by **Durbatuluk** » Fri Dec 25, 2009 8:04 am

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

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;

Neuropass · 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.

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

ofcourse

try asking into the 3.1 support forum

Post by **stevemaury** » Sat Oct 31, 2015 12:58 pm

What is the syntax error and what database are you using?

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

Neuropass · 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?

RMcGirr83 · 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;

advertisements