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.
Run this query, replacing 1 with the group id.
UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` = 1
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?
Try this...
UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` != 1
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?
I just posted a solution in your other topic which doesn't involve altering the database.
What is the membergroup number for all regular members?
0
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?
Lainaus käyttäjältä: Labradoodle-360 - lokakuu 20, 2011, 08:22:56 IP
Try this...
UPDATE `smf_members`SET `avatar` = '' WHERE `id_group` != 1
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.
So there is no way to drop all members avatars???
Can one of the top experts help me out on this please?