Drop all avatars of a membergroup

[PLAYBOY]

Can anybody make a mod which will put an option/setting to take down a specific membergroups avatar?

Right now you can prevent people putting avatars. But you cant take down current avatars of a membergroup. I need this option very much. I would appreciate any help.

[Matthew K.]

Run this query, replacing 1 with the group id.

Koodi [Valitse] Laajenna

UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` = 1

[PLAYBOY]

I ran this query with the group = 0

Because i want all the regular members to be effected.
It said "218 rows affected. ( Query took 0.0213 sec )"

But Everybody still have their avatars.

What did i do wrong?

[Matthew K.]

Try this...

Koodi [Valitse] Laajenna

UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` != 1

[PLAYBOY]

When i query UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` = 0
It said "218 rows affected. ( Query took 0.0213 sec )"

But all the avatars are still there. So what did i change with that query?



Is the "0" for all the regular members?

[Kays]

I just posted a solution in your other topic which doesn't involve altering the database.

[PLAYBOY]

What is the membergroup number for all regular members?

[live627]

0

[PLAYBOY]

So i was right.
Well then what did i change with this query?
UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` = 0



Will this one drop all the avatars without any problem for sure?

Try this...

Koodi [Valitse] Laajenna

UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` != 1

[Kays]

The avatar in the members table only holds the avatar name if it's from an avatar set or a remote avatar. For other avatars, the attachments table is queried.

So that won't clear all of the avatars.

[PLAYBOY]

So there is no way to drop all members avatars???
Can one of the top experts help me out on this please?