vb.org Archive - where do attachments go

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - where do attachments go (https://vborg.vbsupport.ru/showthread.php?t=55177)

otacon

07-10-2003 05:09 AM

where do attachments go

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

Gavin B.

07-10-2003 06:06 AM

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

Roody

07-10-2003 02:15 PM

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

Gavin B.

07-10-2003 03:24 PM

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 ;)

Code:

DELETE FROM attachments WHERE dateline < somedate

and..

Code:

UPDATE post SET attachmentid=0 WHERE dateline < somedate

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

Roody

07-10-2003 07:05 PM

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

07-10-2003 09:56 PM

Attachments should be removed with their posts during pruning.

Roody

07-10-2003 11:15 PM

Quote:

Today at 06:56 PM cirisme said this in Post #6
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?

All times are GMT. The time now is 01:44 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02102 seconds Memory Usage 1,720KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: