vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Removing all attachments from only one forum? (https://vborg.vbsupport.ru/showthread.php?t=143383)

tamborinegal 03-28-2007 03:56 AM

Removing all attachments from only one forum?
 
I have one forum from which I'd like to delete all the attachments from all threads. Does anyone know how I could go about this. Maybe by a sql command?

Thanks

Clancy

tamborinegal 03-31-2007 04:16 AM

Can anyone help me with this or will I need to go through and delete attachments from each thread one by one?

Clancy

Marco van Herwaarden 03-31-2007 07:21 AM

A trick that might work is the following:
- Select all threads in the forum
- Soft Delete them, choosing NOT to keep attachments
- Undelete the threads

tamborinegal 03-31-2007 09:27 AM

Thanks for the reply Marco.

That might be the best way to go about it, but I guess I'd still have to do it page by page then wouldn't I? Still better than thread by thread... but there are over 1500 of them.

Clancy

Marco van Herwaarden 03-31-2007 10:05 AM

Set your forum (temporarily) to show 500 threads on page, use the small down-arrow in the top of the thread listing of the forum to select all threads, perform actions. Only 3 pages, shouldn't take more then a few minutes.

tamborinegal 03-31-2007 11:38 AM

Excellent! Thank you so much Marco.

Cheers

Clancy

Marco van Herwaarden 03-31-2007 12:12 PM

Hehe, glad that worked, sometimes a bit of thinking outside of the box can do the trick and you don't need a modification.


All times are GMT. The time now is 02:35 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.01695 seconds
  • Memory Usage 1,712KB
  • 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
  • (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