Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 03 Oct 2016, 15:04
Morrus Morrus is offline
Join Date: Jan 2002
Avatar Removal SQL Query

I'm having a bit of an issue with avatars remaining after a paid subscription expires.

What is the SQL query I would use in the AdminCP to remove all avatars from users not currently in Usergroup X OR Usergroup Y, either primary or secondary?

(in other words, Primary X, Secondary X, Primary Y, and Secondary Y should all keep their avatars, but everybody else should not)?

Second question:

How would I do exactly the same thing for signatures?

Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 09:16.

Layout Options | Width: Wide Color: