Delete avatars by usergroup - vb.org Archive

		vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
Delete avatars by usergroup

Reply

#1

Old

06-19-2003, 09:08 PM

Night Owl

Night Owl is offline

Join Date: May 2002

Location: Oklahoma

Posts: 95

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Delete avatars by usergroup

I need to delete all avatars belonging to users in a specific usergroup. What query can I use to do this?

Reply With Quote

#2

Old

06-19-2003, 09:40 PM

filburt1

filburt1 is offline

Join Date: Feb 2002

Location: Maryland, US

Posts: 6,144

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

I think:
[sql]
DELETE FROM customavatar WHERE user.userid = customavatar.userid AND user.usergroupid = usergroupid;
[/sql]

Reply With Quote

Reply

« Previous Thread | Next Thread »

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 Forum Rules

Forum Jump

All times are GMT. The time now is 02:42 AM.