vb.org Archive

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 12:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00979 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