Need a query to remove attachments
 

Anyone have a query they can throw my way that will remove all attachments in a specific forum?

You will have to join with the post and the thread table to find out in which forum an attachment is posted.

You will need at least mySQL 4.0.2 for this type of query:

[sql]
DELETE FROM attachment USING attachment, post, thread WHERE attachment.postid = post.postid AND thread.threadid = post.threadid AND thread.forumid = X
[/sql]

Thanks, seemed to work fine :)