The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Need a query to remove attachments
Anyone have a query they can throw my way that will remove all attachments in a specific forum?
|
#2
|
|||
|
|||
You will have to join with the post and the thread table to find out in which forum an attachment is posted.
|
#3
|
||||
|
||||
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] |
#4
|
||||
|
||||
Thanks, seemed to work fine
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|