How to remove existing avatars for an entire usergroup?

[badgerracing]

I use subscriptions on my forum to allow paid members to upload avatars and profile pics as well as other benefits.

The paid subscription task that processes expired subscriptions does not remove the users custom avatar and custom profile pic after the subscription expires.

I used to go in every 6 months to a year and delete avatars manually, but now with 3400 members I can't keep up. I'd like to know if this process from back in '04 (3.0) will work on current VB installs and if so can I edit the php file to replace "customavatar.xxx" with "customprofilepic.xxx" to run the same cleanup for custom profile pics?

http://www.vbulletin.com/forum/showthread.php?t=101614

Tested on 3.0.0

With the introduction of secondary groups in vB3, querying your database based on group memberships isn't as easy as it used to be. A custom script is required to determine group membership status.

When deleting avatars there are two cases to consider, custom avatars and predefined avatars. Each case is addressed below:

Remove custom avatars:
You can run the delete_custom_avatars.php file (attached to this post) from your forum directory to delete custom avatars for any group, just change this line in the file:

 // USERGROUPID OF USERGROUP FROM WHICH TO DELETE CUSTOM AVATARS
 $groupid = 2; 

This file will remove custom avatars for all members of $groupid, that includes both primary and secondary memberships.

Remove predefined avatars:
You can run the delete_predefined_avatars.php file (attached to this post) from your forum directory to remove the predefined avatars for any group, just change this line in the file:

 // USERGROUPID OF USERGROUP FROM WHICH TO DELETE PREDEFINED AVATARS
 $groupid = 2; 

This file will remove predefined avatars for all members of $groupid, that includes both primary and secondary memberships.

BACKUP FIRST!

Thanks.

[badgerracing]

I have searched (before I created this thread) numerous times on this topic and cannot find anything definitive for 3.8 (current) release. I can't be the only one who needs this.

Thanks.

[badgerracing]

Hello? Does anybody work here?

[badgerracing]

Hello? How can this thread be ignored for so long?