where do attachments go

[otacon]

IS there some sort of DIR that attachments go ? If not where do they go??

[Gavin B.]

They're stored as binary within the forum database :)

[Roody]

How do we get to them exactly in order to clean some up or remove them?

[Gavin B.]

do you have phpmyadmin? :)
Open up the database then run the following queries
Back up your database, just incase you lose all of your attachments, or my queries have a mistake in them (they're simple, so they shouldn't :D). Disclaimer: I take no responsibilty for any bad things that might happen ;)


DELETE FROM attachments WHERE dateline < somedate


and..


UPDATE post SET attachmentid=0 WHERE dateline < somedate


if your forum is large, it might take a bit to update the posts. :)

[Roody]

How would you break down the date in that code? For example let's say you wanted to remove everyone attachment before may 15, 2003.

How would you code that exactly?

[cirisme]

Attachments should be removed with their posts during pruning.

[Roody]

Today at 06:56 PM cirisme said this in Post #6 (https://vborg.vbsupport.ru/showthread.php?postid=416800#post416800)
Attachments should be removed with their posts during pruning.

Personally Im more interested in removing certain attachments as opposed to the attachment and posts. Any ideas on how to correctly enter the date?