attachment.php causing high server load??
 

I need to do a mass prune of attachments for certain forums. Anyone have an SQL query that I can use? Something like...

SELECT * FROM `mydatabase`.`thread` WHERE `forumid` = '25'

and then DELETE those attachments that are associated with that forumid??

Also my attachments are served from the filesystem so whatever I use I'm probably gonna have to use some kinda php script for this so that it can delete the attachment entries from the database AND the filesystem =/

I doubt would make any difference. I suggest you post in the Server Configuration forum at vBulletin.com.